[egenix-users] ODBC encoding problems

[M.-A. Lemburg]

On 2007-10-29 11:30, Martijn Pieters wrote:
>> Perhaps isql is setting the character set explicitly, while using
>> the FreeTDS driver via mxODBC picks up a default encoding via
>> some locale environment variable ?
>>
>> Try adding an explicit line
>>
>>         client charset = ISO-8859-1
>>
>> to your freetds.conf file.
> 
> BINGO. I had tried setting client charset to other values, just not to
> the default. But with this line added, mx.ODBC is given the correct
> character set too!
> 
> Thanks, guys, for helping out here, we just saved £499 on a EasySoft
> ODBC driver license.

You're welcome :-)

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Oct 29 2007)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::


   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611