# NUMERIC vs. NUMBER type conversion

**URL:** <https://forum.liquibase.org/t/numeric-vs-number-type-conversion/1620>\
**Category:** General Discussion\
**Created:** [September 19, 2011, 10:18pm UTC](https://forum.liquibase.org/t/numeric-vs-number-type-conversion/1620 "2011-09-19T22:18:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [September 19, 2011, 10:18pm UTC](https://forum.liquibase.org/t/numeric-vs-number-type-conversion/1620/1 "2011-09-19T22:18:00Z")

</div>

Hi,

&nbsp;

I see that some work was done recently for handling NUMERIC vs NUMBER for some other databases…

&nbsp;[http://liquibase.jira.com/browse/CORE-879](http://liquibase.jira.com/browse/CORE-879)  
[http://liquibase.jira.com/browse/CORE-866](http://liquibase.jira.com/browse/CORE-866)  
[http://liquibase.jira.com/browse/CORE-843](http://liquibase.jira.com/browse/CORE-843)  
[http://liquibase.jira.com/browse/CORE-863](http://liquibase.jira.com/browse/CORE-863)  
[http://liquibase.jira.com/browse/CORE-984](http://liquibase.jira.com/browse/CORE-984)

&nbsp;

I have upgraded to use v.2.0.2 of liquibase,

However&nbsp;generateChangelog is&nbsp;still&nbsp;using ‘NUMBER’ for&nbsp;Sybase instead of ‘NUMERIC’

&nbsp;

CORE-843 mentions a possible workaround of creating a subclass for \*TypeConverter in subpackage of liquibase.ext.

But I’m pretty new to liquibase so not sure how I might do that.&nbsp;

Do I need to do it in source and recompile?&nbsp;

or can I add something externally and have it picked up at runtime?

&nbsp;

I see the converters in

liquibase/database/typeconversion/core but nothing for ‘liquibase.ext’ as mentioned above.

&nbsp;

-Chad

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [September 19, 2011, 10:18pm UTC](https://forum.liquibase.org/t/numeric-vs-number-type-conversion/1620/2 "2011-09-19T22:18:00Z")

</div>

&nbsp;

FYI:

I created [http://liquibase.jira.com/browse/CORE-1031](http://liquibase.jira.com/browse/CORE-1031)&nbsp;for NUMERIC conversion&nbsp;in&nbsp;Sybase

&nbsp;

However I still have the question above on how/if something can be done externally.

&nbsp;

Thanks,

-Chad

---

<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:** [September 19, 2011, 10:18pm UTC](https://forum.liquibase.org/t/numeric-vs-number-type-conversion/1620/3 "2011-09-19T22:18:00Z")

</div>

To create an extension, you need to make a java class in a liquibase.ext package. There are no .ext classes in the main liquibase codebase because there are no extensions in there. See [liquibase.org/extensions](http://liquibase.org/extensions) for more info on the extension system.

You don’t need the liquibase source to build an extension, just the liquibase jar in your classpath when creating your extension class.

I committed your change to 2.0.3. Sorry for missing it in 2.0.2, I don’t have a great sybase instance to test against