client encoding mismatch

From: "Brian J(dot) Erickson" <ericksbr(at)infocon-inc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: client encoding mismatch
Date: 2007-07-31 23:52:32
Message-ID: D574AF732EF64619AAE60C89374DFA27@p000014
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Ralph Smith 2007-07-31 23:53:34 Re: Auto Starting +/or Shutdown on OS X
Previous Message Vyacheslav Kalinin 2007-07-31 23:33:20 Re: Polymorphic functions' weird behavior