Re: Force use of UTF-8 instead of ISO8859-1

"James K. Lowden" <[email protected]> Thu, 28 Jan 2010 01:23:03 -0500

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

Michael Mata wrote:
> I'm running CentOS 5.3, freetds-patched (0.82), and pyodbc 2.1.6, which
> I use to connect to SQL Server 2005.  My freetds.conf file:
> 
> [global]
>         tds version = 8.0
>         client charset = UTF-8
>         text size = 32768

If your odbc.ini isn't using freetds.conf, you won't pick up the client
charset. Make sure you're using "servername" and not "server".  

The default should come from your environment, though.  What does tsql
report when you log in?  

--jkl