Chinese character become ??? by pymssql or pyodbc

[James Su]

I tried to use pymssql to access MSSQL 2000, with a table, I store
Chinese Character in NVarchar field, Chinese Character display
normally when I query them by MS SQL Query Analyzer under Windows or
by unixODBC under Ubuntu.
But when I query those data by pymssql or pyodbc, all Chinese
Character display ??? instead.
Does anyone has some advice or thread? Thanks.

 

[Jeroen Ruigrok van der Werven]

But when I query those data by pymssql or pyodbc, all Chinese
Character display ??? instead.

Sounds like you are getting typical Unicode replacement characters.