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: Michael Mata <michaelvmata AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Force use of UTF-8 instead of ISO8859-1
  • Date: Wed, 27 Jan 2010 23:14:54 -0800

I pass the server name, port, user name, password in the connection string.
My odbc.in only has the following linesi:

[SQL Native Client]
Description = SQL Native Client
Driver = /usr/local/lib/libtdsodbc.so
Setup = /usr/local/lib/libtdsS.so
UsageCount = 1
FileUsage = 1

When I run tsql with no parameters:

locale is "en_US.UTF-8"
locale charset is "UTF-8"


On Wed, Jan 27, 2010 at 10:23 PM, James K. Lowden <jklowden AT freetds.org>wrote:

> 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 mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page