Chinese character become ??? by pymssql or pyodbc

Discussion in 'Python' started by James Su, Apr 14, 2008.

  1. James Su

    James Su Guest

    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.
    James Su, Apr 14, 2008
    #1
    1. Advertising

  2. -On [20080414 10:31], James Su () wrote:
    >But when I query those data by pymssql or pyodbc, all Chinese
    >Character display ??? instead.


    Sounds like you are getting typical Unicode replacement characters.

    --
    Jeroen Ruigrok van der Werven <asmodai(-at-)in-nomine.org> / asmodai
    イェルーン ラウフロック ヴァン デル ウェルヴェン
    http://www.in-nomine.org/ | http://www.rangaku.org/
    >From here, what you see you become...
    Jeroen Ruigrok van der Werven, Apr 14, 2008
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Josh Close
    Replies:
    0
    Views:
    494
    Josh Close
    Jul 22, 2004
  2. Replies:
    0
    Views:
    530
  3. morris carre

    encoding problems with pymssql / win

    morris carre, Feb 11, 2006, in forum: Python
    Replies:
    1
    Views:
    351
    morris carre
    Feb 11, 2006
  4. Replies:
    1
    Views:
    833
    Steve Holden
    Feb 16, 2006
  5. sam
    Replies:
    0
    Views:
    348
Loading...

Share This Page