[freetds] Character set problem

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Wed Sep 15 05:36:55 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

Usually problem it's client charset. Client charset should include your
'a unlaut'. Also your libiconv have to support this charset. Try using
GNU iconv or just enable logging and see it charset initialization it's
successful.

freddy77



More information about the FreeTDS mailing list