Thread: client encoding mismatch

client encoding mismatch

From

"Brian J. Erickson"

Date:

31 July 2007, 23:53:21

Hello,

I am getting the following error:
    client encoding mismatch
    State:22003,Native:214,Origin:

Using the function "SQLDriverConnect"
with the connection string
"DSN=PostgreSQL;Servername=server;UID=user;Password=xxxxxx;Database=database
;"

OS: Windows 2000
Postgresql Server 8.1.3
ODBC: 7.03.01.14 'PostgreSQL' driver
(Want to retain, because I am also accessing a 7.x database)

I have done the following:
SET CLIENT_ENCODING TO 'SQL_ASCII';

but the encoding keeps coming back as "UTF8" or "WIN1251"

Please help.

Brian