A new topic, 'Oracle and Integer types', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=172.new#newThe text of the topic is shown below:
Hi,
SmallInts and Integers are not coming out in Oracle as I would think?
Lets say I have:
<column name="BIGINTTYPE" type="java.sql.Types.BIGINT"/>
<column name="INTTYPE" type="java.sql.Types.INT"/>
<column name="SMALLINTTYPE" type="java.sql.Types.SMALLINT"/>
On MySQL, MSSQL, etc, the column types are what I would expect. In Oracle, SMALLINT is mapped to Number and INT is mapped to INT. Both Number and INT are the same as Number(38) in Oracle I think. This ends up making a SmallInt and a Int bigger than the BIGINT which is Number(19,0). Is there a generic way to specify a SmallInt when creating columns that will come out to a SmallInt on each DB?
Thanks,
Alana
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user
