Post reply

SQL Server 2008-Chinese Character insertion

  • August 24, 2009 at 3:47 am

    #213727

    We need to insert chinese characters in a sql server 2008 database. We use the insertion convetion of N'character' but still it inserts as '?'... what should be the encoding type of the script (.sql file) used to insert chinese characters?

  • August 24, 2009 at 8:19 am

    #1043644

    The encoding should be the version of Chinese you are storing and in 2008 you need to use Nvachar for your column data type. The link below covers all the Windows collations you can use including many Chinese. Post again if you still need help.

    http://msdn.microsoft.com/en-us/library/ms143508.aspx

    Kind regards,
    Gift Peddie

  • August 28, 2009 at 3:50 am

    #1046093

    Thanks for response. In my case issue was with encoding type of the script used, once converted to utf-8 and deployed issue was solved.

    Hasini...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply