PostgreSQL Connect

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
nelson.cardoso
Posts: 5
Joined: Wed 14 May 2014 12:45

PostgreSQL Connect

Post by nelson.cardoso » Wed 14 May 2014 12:59

hi,

how to solve???

SQL Server Error: invalid value for parameter "client_encoding":"WIN1252"

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: PostgreSQL Connect

Post by AlexP » Wed 14 May 2014 13:20

Hello,

Please describe the problem in more details: at what exact moment does the error occur (provide the Delphi code), what versions of PostgreSQL, IDE and driver are you using?

nelson.cardoso
Posts: 5
Joined: Wed 14 May 2014 12:45

Re: PostgreSQL Connect

Post by nelson.cardoso » Wed 14 May 2014 14:03

The error occore in connection db (SQLConnection1.Open)

I'm using: PostgreSQL Version 9.3
Driver Devart 3.3.5 21-Feb-14
Delphi 7

nelson.cardoso
Posts: 5
Joined: Wed 14 May 2014 12:45

Re: PostgreSQL Connect

Post by nelson.cardoso » Wed 14 May 2014 16:49

With pgAdmin I can connect without problem.

Client: ENCODING = 'LATIN1'
TABLESPACE = pg_default
LC_COLLATE = 'C'
LC_CTYPE = 'C'
CONNECTION LIMIT = -1;

Server: ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'C'
LC_CTYPE = 'C'
CONNECTION LIMIT = -1;

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: PostgreSQL Connect

Post by AlexP » Fri 16 May 2014 08:40

Please don't create similar topics, I have answered you in http://forums.devart.com/viewtopic.php?f=35&t=29595

Post Reply