Re: LATIN1/9 conversion.... - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: LATIN1/9 conversion....
Date
Msg-id 20060209152101.GA1178@soptik.pzkagis.cz
Whole thread Raw
In response to LATIN1/9 conversion....  ("Tim Clarke" <Tim.Clarke@manifest.co.uk>)
List pgsql-odbc
Hello,

  I'm not much experienced in encoding.

> You can clearly see my latin1 request followed shortly by the latin9. I
> have examined the ODBC code and it looks like the culprit is a code page
> of 1252.

It could be interesting to see mylog output from Windows.
I don't understand well why it choose latin1 and then latin9.
Don't you specify 'set client_encoding to latin1' in DataSource
settings?
I'm new developer since 08.01 version so please be patient with me.

> Am I tracing this right? What do I do about? Suggestions, please!

You could use way of unicode driver. It use UTF-8 so no error occurs
with latin 1 x latin 9.
It means you may use "PostgreSQL Unicode" driver instead of
"PostgreSQL ANSI"

To other developers:
  Another one user points to problems with win1252 -> Latin 9 mapping.
It seems to me that Latin 9 isn't right default choise for win1252.
What do you mean?

Regards,

Luf

pgsql-odbc by date:

Previous
From: Shelby Cain
Date:
Subject: Re: Problem using ODBC from .NET framework
Next
From: Ludek Finstrle
Date:
Subject: Re: COPY FROM