freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Force use of UTF-8 instead of ISO8859-1

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Force use of UTF-8 instead of ISO8859-1
Date: Thu, 28 Jan 2010 01:23:03 -0500

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

[freetds] Force use of UTF-8 instead of ISO8859-1, Michael Mata, 01/27/2010
- Re: [freetds] Force use of UTF-8 instead of ISO8859-1, James K. Lowden, 01/28/2010
  - Re: [freetds] Force use of UTF-8 instead of ISO8859-1, Michael Mata, 01/28/2010
    - Re: [freetds] Force use of UTF-8 instead of ISO8859-1, Michael Mata, 01/28/2010
      - Re: [freetds] Force use of UTF-8 instead of ISO8859-1, Frediano Ziglio, 01/28/2010
        
        Re: [freetds] Force use of UTF-8 instead of ISO8859-1, jklowden, 01/28/2010
  - Re: [freetds] Force use of UTF-8 instead of ISO8859-1, Michael Mata, 01/28/2010