SQL Server Performance

Chinese Character Display.......please advise...

Discussion in 'SQL Server 2005 General Developer Questions' started by sql_jr, Jan 29, 2009.

  1. sql_jr New Member

    Hello, I've loaded some data into a DB with chinese characters. When I cut and paste from a query result window into word, it display correctly. Otherwise, it shows boxes
    How to make it display correctly in Query Analyzer Result tab??? Please give steps. THX!
  2. MohammedU New Member

    I don't think you can display in chinese unless you install with different sort order...but I am not sure...
    To store the characters you have to use unicode...I believe you are using it because it is displaying as square/box otherwise it will be diplayed as '?'
  3. MohammedU New Member

    I am able to figure it out how to display...
    you need to change the your setting in QA connection options...
    go to TOOLS/OPTIONS/FONTS/RESULTS
    Then change FONT setting to CHINESE to display them in chinese...

Share This Page