| Issue 262: | query result ??????? | |
| 1 person starred this issue and may be notified of changes. | Back to list |
What steps will reproduce the problem?
1.Connect to a SQL SERVER 2005 Database
2.My code is below:
cnxn = pyodbc.connect('DSN=winspeed2;CHARSET=UTF8LANGUAGE=th_TH')
cursor = cnxn.cursor()
#CustCode = 10399
cursor.execute("SELECT CustCode, CustTitle, CustName, CustAddr1 FROM EMCust WHERE CustCode = ?", vals['code'])
rows = cursor.fetchall()
print rows
print '-----------------------'
print rows[0][2]
3. result of query is bolow:
[('10399', '??????', '??? ?? ?? ???????????? ?????', '155/3 ?????????????? ??
????????')]
-----------------------
??? ?? ?? ???????????? ?????
What is the expected output? What do you see instead?
result I got is ????? but I want a result that show right language.
What version of the product are you using? On what operating system?
I am using Python 2.7,SQL SERVER, and pyodbc module 3.0.5, windows xp and window server 2003
Please provide any additional information below.
I should show thai language not "????". I query data form sql server and insert in to postgresql.
May 23, 2012
Project Member
#1
mkleehammer
Status:
Hold
|