[freetds] Character set problem

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Thu Sep 16 05:02:26 EDT 2004


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



More information about the FreeTDS mailing list