Re: problem connecting via ODBC when unicode (now in correct forum.). - Mailing list pgsql-odbc

From Kim Mortensen
Subject Re: problem connecting via ODBC when unicode (now in correct forum.).
Date
Msg-id AANLkTi=___v-bo-UHZtg5=6xPwEeMXJx3y+ZC6SzTOVD@mail.gmail.com
Whole thread Raw
In response to Re: problem connecting via ODBC when unicode (now in correct forum.).  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: problem connecting via ODBC when unicode (now in correct forum.).
List pgsql-odbc
But the connector is configures individually and I specify the encoding by the configuration string sat in the JDBC driver. this string sets the encoding, but apparently it does not work.

BEst Regards
Kim Mortesnen

2011/1/21 Adrian Klaver <adrian.klaver@gmail.com>
On 01/21/2011 12:35 PM, Kim Mortensen wrote:
Adrian,

Tje letters you are typing are from Danish, but any will do.

Now im working abit from memory, but when the databse is build, initdb
is using UNICODE as encoding, "C" for locale, so it should be
independant of the locale settings.

I believe the problem, as Hiroshi Saito pointed out, is that the client encoding is being set on Windows before the connection is attempted and that it is picking the wrong one. Per his post pgAdmin and JDBC are probably just starting with UTF8 and that is why they succeed. At this point I don't know how to get around that.


Best Regards
Kim Mortensen


--

pgsql-odbc by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: problem connecting via ODBC when unicode (now in correct forum.).
Next
From: Adrian Klaver
Date:
Subject: Re: problem connecting via ODBC when unicode (now in correct forum.).