FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

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