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
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 |