Skip to Content.
Sympa Menu

freetds - RE: [freetds] Character set problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: <hannu AT listserv.kuntaliitto.fi>, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Cc:
  • Subject: RE: [freetds] Character set problem
  • Date: Wed, 15 Sep 2004 11:36:55 +0200

>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page