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: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Character set problem
  • Date: Thu, 16 Sep 2004 11:02:26 +0200

> >
> > 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. ---End Original
> Message---
> >
> > Hej Hannu!
> >
> > I assume you're using TDS 0.62 or later.
>
> TDS 0.62.4, so your assumption holds.
> >
> > Show us your freetds.conf and a short TDSDUMP log, just to make sure
> > things are set up right. It would be good if the log
> included a query
> > with a failed conversion.
>

Mmmm... it's a bug of FreeTDS. I'll fix ASAP.
FreeTDS consider only LCID and not sql collation. In this case LCID
(0x40b) correspond to CP1252 while your sql collation correspond to
CP850.

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page