Why is the length of a decimal/numeric column predefined?

Dec 1, 2009 at 3:30 PM


What is the reason that the length of decimal or numeric columns are predefined (13, 4)? I have imported a database that uses decimal(18, 2), but when I change something in the column definition in the model and update the database, then the column is adjusted to the default length. I understand that the various int types are predefined, but the length of a decimal is configurable, at least in SQL 2008.


Dec 2, 2009 at 12:40 PM

Right now it is hard wired at (13, 4) however we are working on making this configurable. I have no work around for your right now. We should be able to address this in the next week or so.

Dec 3, 2009 at 2:57 PM

It is good to know that this issue is currently in development. I look forward to that version.

Dec 13, 2009 at 9:09 AM

The option to define the length of a decimal/numeric field would be a great feature. It will solve a lot of our problems too.

Thank in advance and keep up the good work.

Dec 14, 2009 at 1:49 PM

Please get the latest version. There is a scale property for columns that applies to decimal data types. I think this is what you need to control.

Also you can stay updated on new releases on Twitter at http://twitter.com/nhydrate and LinkedIn http://www.linkedin.com/home?myGroups=&trk=hb_side_grps