client encoding mismatch - Mailing list pgsql-general

From Brian J. Erickson
Subject client encoding mismatch
Date
Msg-id D574AF732EF64619AAE60C89374DFA27@p000014
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: "Vyacheslav Kalinin"
Date:
Subject: Re: Polymorphic functions' weird behavior
Next
From: Ralph Smith
Date:
Subject: Re: Auto Starting +/or Shutdown on OS X