pyodbc utf-8

2012-12-06 Thread Markus Christen 
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.

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

Re: pyodbc utf-8

2012-12-07 Thread 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

-- 
http://mail.python.org/mailman/listinfo/python-list

Re: pyodbc utf-8

2013-01-07 Thread Markus Christen 
When i look at my output on my webpage, i can see this:
W\xe4denswil
but it have to be this:
Wädenswil
you know now what i can see exactly... im using django and they told me its a 
python problem with utf-8. when i turn off debug, i cant see the page, it give 
me an error 500.
the text "Danke für die..." on the bottom of my page is displayed correct. the 
error comes only when an umlaut is to post, out of the raw.
-- 
http://mail.python.org/mailman/listinfo/python-list