From: | orgilhp <orgilhp(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pymssql: Problem with Unicode string |
Date: | 2011-01-29 14:52:33 |
Message-ID: | aace5677-7d0c-41fe-9657-922012ed6dc6@u11g2000prk.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 2011-01-29 16:20:03 | Re: Adding more space, and a vacuum question. |
Previous Message | Matt Warner | 2011-01-29 14:46:43 | Re: Full Text Index Scanning |