[freetds] Force use of UTF-8 instead of ISO8859-1
Michael Mata
michaelvmata at gmail.com
Thu Jan 28 02:14:54 EST 2010
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
>
More information about the FreeTDS
mailing list