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

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 <[email protected]>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
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>