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
--
http://mail.python.org/mailman/listinfo/python-list
