• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

SQL Language Version

Here is my question.

Is there any SQL version that can accomondates English (as we normally use!) and Chinese character in the SQL tables? If there is any? Anyone can provide me any example?

Please help.

Thanks.
0
woo_kh
Asked:
woo_kh
1 Solution
 
russellshomeCommented:
You can specify collation at the column level in SQL Server 2000. A datatype of nvarchar will store unicode which I assume can cope with chinese. Unfortunately, I don't have an example - hope this points in the right direction.
0
 
woo_khAuthor Commented:
Hi mate,

I have got the Chinese character in the SQL server table by installing NJ STAR CJK viewer which allowed me to view the Chinese characters.  

Thanks for your help.

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now