Numeric datatypes with Firebird and Sqlserver

Joao Cadilhe · Post by **Joao Cadilhe** » Thu 27 Mar 2008 13:44

Congratulations, UniDAC is really impressive!

I'm testing latest Version with SqlServer support.

When i set EnableBCD and EnableFMTBCD options of UniQuery to True i have :

Firebird:
Numeric(5,2),Numeric(10,4), Numeric(18,4) : Mapped to TBCDField.
Numeric(18,6): Mapped to TFMTBCDField.
All tests with firebird OK.

SqlServerExpress 2005:
Numeric(5,2),Numeric(10,4), Numeric(18,4) : Mapped to TBCDField. (OK)
Numeric(18,6): Mapped to TBCDField.
When i save the record to Database, Numeric(18,6) field value is rounded with four decimal places.

It's a problem to me because i need to change from Firebird to SqlServer using same application.

Do you have any idea about this issue?

Joao Cadilhe.

Challenger · Post by **Challenger** » Thu 27 Mar 2008 14:41

This is a bug and it will be fixed in the nearest time. As a temporay solution we can suggest you to map all numeric fields to the TFMTBCDField. To do this you should set EnableBCD to False and EnableFMTBCD to True.

Joao Cadilhe · Post by **Joao Cadilhe** » Thu 27 Mar 2008 15:51

It's ok. Thank you.