locked
Records contain English and Chinese words RRS feed

  • Question

  • Hi,

    In the table, I want to insert both English and Chinese characters.

    But I found that Chinese characters are displayed as "??" something like.

    I used SQL Server 2008 R2.

    Locale is United States. Thanks for help.

     

    Thursday, July 1, 2010 1:28 AM

Answers

  • What is the type of the field you're using? It should be nvarchar type.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Proposed as answer by Grant Guan Thursday, July 1, 2010 2:12 AM
    • Marked as answer by ardmore Thursday, July 1, 2010 8:49 PM
    Thursday, July 1, 2010 2:01 AM

All replies

  • Please have a look of International Considerations for SQL Server: http://msdn.microsoft.com/en-us/library/ms142795.aspx

    and International Considerations for Databases and Database Engine Applications: http://msdn.microsoft.com/en-us/library/ms190245.aspx which is a section of the 1st link.

    Hope it helps.

    • Proposed as answer by Naomi N Thursday, July 1, 2010 2:00 AM
    Thursday, July 1, 2010 1:55 AM
  • What is the type of the field you're using? It should be nvarchar type.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Proposed as answer by Grant Guan Thursday, July 1, 2010 2:12 AM
    • Marked as answer by ardmore Thursday, July 1, 2010 8:49 PM
    Thursday, July 1, 2010 2:01 AM
  • displayed as "??"  maybe cos your computer donot have chinese language support.

    usually if you using nvarchar() and insert like

    insert into table values(N'  '),should be ok

    Thursday, July 1, 2010 2:12 AM