Skip to Content.
Sympa Menu

freetds - [freetds] Character set problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Hannu Niemi" <hannu AT listserv.kuntaliitto.fi>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Character set problem
  • Date: Wed, 15 Sep 2004 12:12:19 +0300

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




Archive powered by MHonArc 2.6.24.

Top of Page