Results 1 to 4 of 4

Thread: SQL Server 2008 - Chinese Character

  1. #1
    Join Date
    Aug 2009
    Posts
    2

    SQL Server 2008 - Chinese Character

    What should be the encoding type of the script used to insert chinese characters into the table? Column datatype is NVARCHAR.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    insert table values (..., N'Chinese characters', ...)

  3. #3
    Join Date
    Aug 2009
    Posts
    2
    Thanks for the reply.

    But if I run the insert script from the SQL Mgmt(with N'chinese character'), it inserts perfectly but if script is run from VSTS Build tool, it inserts '?'. Looks as if there is some issue with encoding type format of the script as it is in ANSI. Which encoding type the script must be utf-8/utf-16? And which is supported by SQL Server 2008 for chinese characters.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Take look at 'Managing Data Conversion Between Unicode Encoding Schemes' in sql2k8 books online.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •