Strange string encoding behaviour with pymssql
fabrizio.cornelli at gmail.com
Fri Sep 1 04:59:29 EDT 2006
I'm using pymssql to extract data from a legacy table with a non-ascii
The strange thing is that I can make my query from the idle's console, but
it doesn't work from python. (I'm working in a windows environment)
The error shows that there's a problem related to the encoding, I've tried
to excplicit it in a -*- coding: latin-1 -*- fashion, but it seems it's not
enough. Converting with unicode(query,encode) trying all the known encoding
formats dowsn't work as well.
I tried something like: mssql.query("select id_attività from prodotti") and
I have an error in the form:
pymssql.DatabaseError: internal error: SQL Server message 207, severity 16,
e 3, line 1:
Il nome di colonna 'id_attivitÓ' non è valido.
As you can see 'id_attività' has been wrongly converted in 'id_attivitÓ' .
Why, I wonder, idle's console and pythonwin can manage correctly the string
and python.exe does not?
Is it a problem related to pymssql and this is not the right place where to
post it, or is there someone that could show me a solution?
Thanks in advance for any hint.
Fabrizio Zeno Cornelli
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Python-list