Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drumm
Starting Member
14 Posts |
 Posted - 2003-06-17 : 08:17:05
|
| Hi,we're going to localize one of our applications for use in China. Mandarin has been chosen as the language, but is it possible to store these characters in a VARCHAR? Or a NVARCHAR?Any pros and cons would be greatly appreciated!Thanks in advance,Thomas |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2003-06-17 : 11:58:27
|
| you should use nvarchar to store any unicode values.Remember nvarchar takes 2 bytes to store one character. so the max size is 4k instead of 8k as is the case with varchar.you have convert the character to nvarchar while you are inserting.eg:insert into sometable(field) values(N'chinese characters')HTH-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
 |
|
|
drumm
Starting Member
14 Posts |
Posted - 2003-06-18 : 04:12:06
|
| Thanks for your help, Nazim! |
|
|
|
|
|
|
Chinese characters (Mandarin) in varchar?