April 16, 2009 at 8:29 am
I am working on a web project that need to display and store 3 language: English, Simplified Chinese and Japanse. I need to know which query i need to use to store and fetch the data in these languages and which collation settings i need to use .
Please advise.. My environment is : sql server 2000 .
Thanks
April 16, 2009 at 8:34 am
It's not as much a collation thing as it is a design issue. You'll need to make sure the appropriate tables hold nvarchar instead of varchar, data types, and that variables and such in your code have the same thing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2009 at 8:48 am
English, Chinese and Japanese collation is important because you have three separate alphabets the Latin for English, while both Chinese and Japanese use separate alphabets that is more than 2000 characters which is very relevant in a web application. Check 2000 BOL all three comes with collation defined.
Kind regards,
Gift Peddie
April 16, 2009 at 8:49 am
Thanks for rplying . please let me know i need to some unicode also while inserting values in tables....
April 16, 2009 at 8:55 am
That is correct you need the collation and unicode that is Nchar, Nvarchar and NText. Check the long thread below for all you need to know about this problem and many design options.
http://www.sqlservercentral.com/Forums/Topic205432-230-1.aspx
Kind regards,
Gift Peddie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply