--001636499f6ddd030104612606e0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
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
--001636499f6ddd030104612606e0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div>Hi,</div>
<div> </div>
<div>i'm coding a project in C# / VS2008 and i'm using postgre=
s/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 chars=
et windows is using internally since that is sort of invisible to the progr=
ammer, but i would have assumed it is using some sort of unicode strings.</=
div>
<div> </div>
<div>Anyway, either the OdbcException.Message property does not return a UT=
F-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&quo=
t; character, and currently there is a one-to-one match).</div>
<div> </div>
<div>Everywhere else, unicode/UTF-8 strings works beautifully, in Sort=
ing, LIKE, ILIKE etc throughout the application, and it also looks cor=
rectly when i'm looking at the data using pgAdmin, so it's only the=
error messages that does not work.</div>
<div> </div>
<div>Does anyone have any experience in this and want to share wi=
th me on this one?</div>
<div> </div>
<div>BTW, i'm using the "PostgreSQL Unicode" ODBC driver.</di=
v>
<div> </div>
<div>//Kenneth</div>
<div> </div>
--001636499f6ddd030104612606e0--
