Hi,

I am using NHibernate 1.01 on Sql Server 2000. When I try to map a database field of decimal(16,8), only 5 digits is saved by NHibernate. For example, if I set the property, say a.price = 9.12345678, only 9.12345 is saved to the database field.

I tried to browse the source of 1.01 and found decimal(19,5) is defined in the code. Should I customize such code or what's other options?

Thanks
Hongze

try using flat or double, I belive these are also supported.

Dragos

Specify the correct type in the mapping file, for example type="Decimal(16,8)".

Hi sergey,

Decimal(16,8) works for me. When I saw you replay this morning I tried this type and it works. The strange thing is that I actually tried this yesterday and rebuild the whole project with no luck(I know I need rebuild instead of build the project containing the mapping file). Maybe this morning's reboot refreshed everything.

Thanks for pointing me to the direction.

Dado2003,

Thanks for the suggestion. Because Decimal(16,8) works for me, I didn't proceed to try double. Also, Decimal(16,8) sound technically correct to me.

Thanks again
Hongze