MS SQL, Ubuntu, and UTF-8 problems

[wgw]

I am on Ubuntu 10.04 and trying to get data with international characters (éà etc...) from a remote ms sql server.

With tsql the data comes back with accents intact, so freetds is working properly.

With pyodbc (pyodbc-2.1.7-py2.6-linux-i686.egg), accented characters are scrambled.

With DataManager from unixODBC accented characters are scrambled too. (I read that unixODBC had to be compiled with --with-iconv-char-enc=UTF8 for accents to display properly. )

I am able to interact properly using pymssql, which does not use unixODBC.

Should I try to go up to pyodbc 2.3.1 in order to be able to set the encoding? Or is this a unixODBC issue?

Some discussion....

• https://groups.google.com/d/topic/django-users/AOF1iXtraeU/discussion
• https://groups.google.com/d/topic/django-users/ueQAqHvbzks/discussion
• https://groups.google.com/d/topic/django-users/JPF4WjoG4GY/discussion

[Michael Kleehammer]

If possible, try the Microsoft ODBC driver for Linux. It works very well.

[wgwi...@gmail.com]

Thanks for the feedback: as far as I can tell, it doesn't work with Ubuntu. From the doc (http://www.microsoft.com/en-us/download/details.aspx?id=28160) :

Supported operating systems: linux

Either 64-bit Red Hat Enterprise Linux 5 or 64-bit Red Hat Enterprise Linux 6 with the following RPM packages installed from your distribution’s package repository: