Why NHibernate used Decimal(19,5) for mapping Money type ?

Jericho · **Joined:** Thu Aug 25, 2005 3:14 am **Posts:** 19

Hi!
Hibernate version:1.0.2.0

I'm work with MSSql 2000 and i need to save big value in table who have a column with type Money.
Actually i need save a value = - 1000 000 000 000 00

But NHibernate don't correctly generated insert or update script.
Genetared script included parameter with type Decimal(19,5), but
in MSSql type money must be mapped to type decimal(19,4) (by SQL Server Books Online).

This is mistakes "By design" or I may be don't understand something?

Thanks.

[/code]

sergey · **Posted:** Thu Mar 16, 2006 12:32 pm

You can specify precision and scale of decimals in the mapping, for example:

Code:

The default precision and scale values are more or less arbitrary.

Jericho · **Joined:** Thu Aug 25, 2005 3:14 am **Posts:** 19

Hi Sergey!

sergey wrote:

You can specify precision and scale of decimals in the mapping, for example:

Code:

The default precision and scale values are more or less arbitrary.

It`s really works!!! Thanks!!!!!