[freetds] Charset issues...

Michael Higgins listinfo at banfieldgroup.com
Fri Jul 27 16:49:50 EDT 2007


Folks --

How do I troubleshoot charset issues? I have to match a string, but the string is coming across with a '?' rather than the character it should be. 

Where does freetds determine the charset?

I understand MS SQL Server produces data in a charset.... what happens when it comes via freedts? When I look it up in the mysql database there is a mismatch.

[happily matching names to ids...]
. . .
Little Man Inc. => 1112
name not found: Miller?s Hobbies, Inc. at estes.pl line 100.

Where did that '?' come from?

 locale -a
C
POSIX
en_US.utf8

tsql shell reports:

locale is "C"
locale charset is "ANSI_X3.4-1968"


Can I get a clue? I use Gentoo distro, if that helps.

-- 
Michael Higgins <listinfo at banfieldgroup.com>


More information about the FreeTDS mailing list