Saturday, January 29, 2011

pymssql: Problem with Unicode string

Hello!
I am using pymssql-1.9.908. And I have MSSQL2008 database server.
I ran following code from python 2.6:
-----------------------------------
import pymssql
conn = pymssql.connect(host='testserver', user='sa',
password='sa', database='testdb', as_dict=True)
crms = conn.cursor()
crms.execute('SELECT cc_Name FROM tblUsers')
for line in crms.fetchall():
print 'cc_Name:', self.unicodify(line['cc_Name'])
break
crms.close()
-----------------------------------
the result is-> cc_Name: ?????, ???
But the actual data is "Аймаг, хот" and I expect that the output would
be "cc_Name: Аймаг, хот".

Here is my question:
How to get Unicode data from MSSQL database using pymssql library?

Any suggestion would be highly appreciated!
regards,
Orgil.D

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment