Problem with numeric() type
Posted: Wed 15 Jul 2009 13:45
dbExpress driver for PostgreSQL Product Version: 1.00.4
OS Version: Windows Vista
Platform: x32
I am substituting driver of vitavoom for the one of the Devart, remembering that the system wheel with driver of vitavoom the only difference was the substitution of driver for the one of the Devart, plus this happening the following error in the separator decimal:
'invalid input syntax for type numeric: "21,48"'.
Important: in Brazil, the numeric value formating is: 9.999.999,00 (with "," separeting decimals).
Well, I use PostgreSQL 8.3.7 with Delphi 2009.
I am using domain in postgresql.
configuration of my connection:
BlobSize=-1
HostName=localhost
DataBase=frigo
DriverName=DevartPostgreSQL
User_Name=teste
Password=teste
FetchAll=True
Charset=win1252
UseUnicode=True
DetectParamTypes=False
EnableBCD=False
Schema=public, al, au, co, fi
OS Version: Windows Vista
Platform: x32
I am substituting driver of vitavoom for the one of the Devart, remembering that the system wheel with driver of vitavoom the only difference was the substitution of driver for the one of the Devart, plus this happening the following error in the separator decimal:
'invalid input syntax for type numeric: "21,48"'.
Important: in Brazil, the numeric value formating is: 9.999.999,00 (with "," separeting decimals).
Well, I use PostgreSQL 8.3.7 with Delphi 2009.
I am using domain in postgresql.
configuration of my connection:
BlobSize=-1
HostName=localhost
DataBase=frigo
DriverName=DevartPostgreSQL
User_Name=teste
Password=teste
FetchAll=True
Charset=win1252
UseUnicode=True
DetectParamTypes=False
EnableBCD=False
Schema=public, al, au, co, fi