Localized error messages, wrong charset

From: Kenneth Lundin <kenneth(dot)lundin(at)dacom(dot)se>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Localized error messages, wrong charset
Date: 2009-01-23 13:04:18
Message-ID: 93d3a1c90901230504u19f6dafau4c04a88aefef55d1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

i'm coding a project in C# / VS2008 and i'm using postgres/ODBC for database
connectivity. Everthing works fine except for one tiny detail, and that is
that i'm having trouble with OdbcExceptions and the Message property. It
seems that the Message is not in the expected charset since all swedish
characters are turned into box-like characters when they are displayed in a
normal MessageBox control. I'm not sure which charset windows is using
internally since that is sort of invisible to the programmer, but i would
have assumed it is using some sort of unicode strings.

Anyway, either the OdbcException.Message property does not return a UTF-8
string, OR it does return a UTF-8 string and Windows can not use that (but I
think it is the first alternative, because if it would have returned UTF-8,
there would have been several box-like characters per "real" character, and
currently there is a one-to-one match).

Everywhere else, unicode/UTF-8 strings works beautifully, in Sorting, LIKE,
ILIKE etc throughout the application, and it also looks correctly when i'm
looking at the data using pgAdmin, so it's only the error messages that does
not work.

Does anyone have any experience in this and want to share with me on this
one?

BTW, i'm using the "PostgreSQL Unicode" ODBC driver.

//Kenneth

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2009-01-23 23:41:23 Re: ODBC and listen/notify
Previous Message Mark Morgan Lloyd 2009-01-22 08:31:21 ODBC and listen/notify