Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1138
  • Last Modified:

what datatype to use for mandarin/chinese character input?

hi,
i need to enter mandarin/chinese characters into my db table. i've set the datatype to varchar and length 1000...however, i cant manage to input chinese/mandarin characters...the error message indicated about my invalid data type and length..so how can i solve this issue? pls help, thanks man.
0
nwhan
Asked:
nwhan
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
You can use nvarchar
0
 
Patrick MatthewsCommented:
Hi nwhan,

You need to use nchar or nvarchar for Unicode.

Regards,

Patrick
0
 
Patrick MatthewsCommented:
Sorry Aneesh, didn't refresh :)
0
 
nwhanAuthor Commented:
thanks man...both of u...but guess aneeshattingal was the 1st to answer..so i'll have to reward him the points...thanks man ...
0

Featured Post

Technology Partners: 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!

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