pyodbc utf-8

[Markus Christen]

My webpage is using UTF-8 and utf-8 or unicode is on the DB. When i read out this files with Excel, i have no problems with the umlauts. I heared its a problem of pyodbc itself, cause it is only using ascii i think. I found this page here, but it was not really helpful for me. :( maybe i have not understood what this really means...
http://stackoverflow.com/questions/4805267/problem-with-unicode-decoding

maybe you can understand it and you can translate it for a noob. :D


Am Freitag, 7. Dezember 2012 13:16:09 UTC+1 schrieb Hans Mulder:
> On 7/12/12 08:41:27, Markus Christen wrote:
> 
> > good morning
> 
> > 
> 
> > i am using pyodbc 3.0.6 for win32 python 2.7.3
> 
> > i used it to connect with a MsSql db. Now i have a little problem with the umlaut.
> 
> > i cant change anything in the db and there are umlauts like "�", "�"
> 
> and "�" saved.
> 
> > so i have to change my view (of django 1.4.1) to change \xfc into � etc. but how i
> 
> > have to do this?
> 
> 
> 
> > on my webpage the umlauts are correct (without helping fonts like ü (�)).
> 
> > but not the umlauts out read out of my db.
> 
> 
> 
> Which encoding does your webpage use?
> 
> 
> 
> > Here the code i'm using:
> 
> > ---------------------------------
> 
> >     conn = pyodbc.connect('DRIVER={SQL Server};CHARSET=UTF8;SERVER=MAURITIUS;DATABASE=baan5c;UID=portal;PWD=P0rtalReader')
> 
> >     cursor = conn.cursor()
> 
> >     cursor.execute("SELECT t_nama, t_bpid FROM ttccom100070 ORDER BY t_nama")
> 
> >     rows = cursor.fetchall()
> 
> > ---------------------------------
> 
> >
> 
> > helping tags like ", 'utf-8'" or something else didnt work till now.
> 
> > have anyone an idea how i can fix this problem? ^^
> 
> 
> 
> I think the way forward would be to look at the data your code snippet
> 
> receives from the database.
> 
> 
> 
> Which datatype do the strings have?  Unicode or str or something else?
> 
> 
> 
> If the type is str, which encoding do they use?
> 
> If this isn't documented, you could at a few strings containing
> 
> non-ascii characters to see what codes are used, and compare
> 
> them to popular encodings such as uft8, latin1 and cp1252.
> 
> 
> 
> 
> 
> Hope his helps,
> 
> 
> 
> -- HansM