search

thegooglecodearchive / pymssql

Automatically exported from code.google.com/p/pymssql
GNU Lesser General Public License v2.1
0 stars 0 forks source link

result of query is ??????? #89

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
I want a data from sql server to insert in postgresql

this is my code:

cnxn = pyodbc.connect('DSN=winspeed2')
cursor = cnxn.cursor()
cursor.execute("SELECT CustCode, CustTitle+' '+CustName AS custName, CustAddr1 
FROM EMCust WHERE CustCode = %s" % vals['code'])
rows = cursor.fetchall()
============================================================
when I raise Exception(rows) result is:
[('10030', '?????? ???.?????? (????????) ?????', '1/24 ???? 5 
??????????????????')]

when I insert to postgresql database , it inserts ??????.
How to solve it.

Original issue reported on code.google.com by kathawu...@gmail.com on 15 May 2012 at 8:02

GoogleCodeExporter commented 9 years ago 
uh, this is pymssql, not pyodbc.

Original comment by rsyr...@gmail.com on 16 May 2012 at 10:49