Decimal Separator, dbExpress, DB2

Abstract: Decimal Separator, dbExpress, DB2

Product: Delphi

Version: 7

Problem Description:

I am writing an application that connects to DB2 via dbExpress. My locale is one that uses a comma as a decimal separator. When I read numbers back, I don't see the decimal separator, ie I expect to see 21,10 but I see 2110.

Problem Resolution:

This is a known limitation of the version of dbExpress that ships with Delphi 7. The dbExpress that is supplied with BDS 2006 has a Decimal Separator property which allows you to configure the decimal separator to the one used by the locale that you are working in.