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?