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. Advertisements

  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. Advertisements

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. =?Utf-8?B?U3BpZGVyX0ppYQ==?=

    how to diaplay chinese character in aspx page

    =?Utf-8?B?U3BpZGVyX0ppYQ==?=, May 27, 2004, in forum: ASP .Net
    Replies:
    3
    Views:
    908
    Natty Gur
    May 28, 2004
  2. Jeff
    Replies:
    3
    Views:
    959
    chris
    Jan 16, 2004
  3. Jeff
    Replies:
    3
    Views:
    962
    Jon A. Cruz
    Jan 17, 2004
  4. chad
    Replies:
    3
    Views:
    801
    Alun Harford
    Mar 5, 2004
  5. KFC
    Replies:
    1
    Views:
    793
  6. Anthony Liu
    Replies:
    0
    Views:
    681
    Anthony Liu
    Mar 6, 2004
  7. Wijaya Edward
    Replies:
    8
    Views:
    445
    J. Clifford Dyer
    Oct 27, 2006
  8. sam
    Replies:
    0
    Views:
    598
Loading...