Re: Help with charset

Are you sure that you are getting UTF-8 from the server?  I know we have on SQL server that we connect to (using freetds) with the client charset = CP1252.

-Casey

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Nelson A. de Oliveira
Sent: Friday, October 14, 2011 09:42
To: [email protected]
Subject: [freetds] Help with charset

Hi!

I am having a small issue with the wrong charset when using freetds.
While testing some queries with sqsh and trying to define the charset
with every method explained in sqsh's manpage (and failing to get the
correct result), I saw that the same wrong behavior is happening with
tsql.

For example, an entry that should be correctly displayed as BÁRBARA
NÓBREGA is being returned as BµRBARA NàBREGA (everything that has an
accent is wrongly displayed).

I have tried to define "client charset = UTF-8" in freetds.conf but I
always get the same wrong results.
Installed freetds is Debian's 0.82-8

Is this something that has been (or could be) fixed in newer versions?
How can I debug this (or correctly define the charset), please?

Thank you very much!

Best regards,
Nelson
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds

This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.