[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