[freetds] Character set problem
Hannu Niemi
hannu at listserv.kuntaliitto.fi
Wed Sep 15 05:12:19 EDT 2004
Hello
I have been digging most of this day about my problem with FreeTDS. I
prefer not to ask when I can find the solution myself, but now I am
pressed by the schedule :(
My main target is PHP-language, but the problem manifests itself also
when using TSQL and Microsoft SQL Server 2000. I'd guess the problem
is
In short, the problem is our national characters (with umlauts) that
are converted to question marks (in SELECT queries at least). When
debugging for example 'a umlaut' is hex 84 (CP850?). The server
collation is SQL_Scandinavian_CP850_CI_AS.
I am running this on SuSE 8.1 and FreeTDS protocol version is 8.0
So, what could and/should I do?
Best regards from Finland
Hannu Niemi
Association of Finnish Local and Regional Authorities
More information about the FreeTDS
mailing list