Problem with numeric() type

Problem with numeric() type

Postby altemar » 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
altemar
 
Posts: 2
Joined: Wed 15 Jul 2009 13:19

Postby Plash » Wed 12 Aug 2009 09:08

We have answered you by e-mail.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Decided

Postby altemar » Wed 12 Aug 2009 11:48

I removed the dominios of postgresql now and this functioning correctly.
altemar
 
Posts: 2
Joined: Wed 15 Jul 2009 13:19


Return to dbExpress driver for PostgreSQL