# Liquibase 2.0:  java.sql.Types.DOUBLE problems on MSSQL 2008

**URL:** <https://forum.liquibase.org/t/liquibase-2-0-java-sql-types-double-problems-on-mssql-2008/986>\
**Category:** General Discussion\
**Created:** [December 9, 2010, 3:30pm UTC](https://forum.liquibase.org/t/liquibase-2-0-java-sql-types-double-problems-on-mssql-2008/986 "2010-12-09T15:30:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dskiles](https://avatars.discourse-cdn.com/v4/letter/d/ad7895/32.png) [@dskiles](https://forum.liquibase.org/u/dskiles)\
**Post date:** [December 9, 2010, 3:30pm UTC](https://forum.liquibase.org/t/liquibase-2-0-java-sql-types-double-problems-on-mssql-2008/986/1 "2010-12-09T15:30:00Z")

</div>

I’m trying to run the following liquibase command on MSSQL 2008 and liquibase is generating SQL that the server doesn’t like. &nbsp;I’ve also included the generated SQL below. &nbsp;In Liquibase 1.9.1 the datatype generated for the value column was FLOAT, rather than DOUBLE. &nbsp;Is there any workaround for this? &nbsp;Also, am I using the tool incorrectly or is this a bug?

 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

CREATE TABLE [dbo].Name] ( &nbsp; &nbsp;[id] CHAR(32) NOT NULL, &nbsp; &nbsp;[value] DOUBLE NOT NULL, &nbsp; &nbsp;CONSTRAINT [PK\_TABLENAME] PRIMARY KEY ([id]) )

---

<div class="post-metadata">

**Author:** ![dskiles](https://avatars.discourse-cdn.com/v4/letter/d/ad7895/32.png) [@dskiles](https://forum.liquibase.org/u/dskiles)\
**Post date:** [December 9, 2010, 3:30pm UTC](https://forum.liquibase.org/t/liquibase-2-0-java-sql-types-double-problems-on-mssql-2008/986/2 "2010-12-09T15:30:00Z")

</div>

If I override getDoubleType() in MSSQLTypeConverter.java as follows, everything seems to work swimmingly.&nbsp; What is the procedure for getting this tested and patched into the mainline?

@Override public DoubleType getDoubleType() { return new DoubleType("FLOAT"); }

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [December 9, 2010, 3:30pm UTC](https://forum.liquibase.org/t/liquibase-2-0-java-sql-types-double-problems-on-mssql-2008/986/3 "2010-12-09T15:30:00Z")

</div>

You can just post the code like you did.&nbsp; I added it to trunk.&nbsp;

Otherwise, everyone with a [liquibase.jira.com](http://liquibase.jira.com) account has commit access to SVN.&nbsp; I’m trying to use it as a pseduo-github type setup for easier contributing so allow commits but review and will modify or comment on any changes committed directly.&nbsp; I leave it up to the contributer to decide how extensive or risky their change is and what the best route to contribute code is.

Nathan