Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page