Problem with numeric() type

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
altemar
Posts: 2
Joined: Wed 15 Jul 2009 13:19

Problem with numeric() type

Post by 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

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Wed 12 Aug 2009 09:08

We have answered you by e-mail.

altemar
Posts: 2
Joined: Wed 15 Jul 2009 13:19

Decided

Post by altemar » Wed 12 Aug 2009 11:48

I removed the dominios of postgresql now and this functioning correctly.

Post Reply