November 9, 2011 at 6:46 am
Is multi-language support turned on in SQL by default?i Do you know what data type should I use for storing other languages?
Any example on this will be highly appreciated.
Bipan
November 9, 2011 at 7:01 am
it depends on what characters the languages use, if you are required to store languages that do not use the latin characters such as Arabic or Thai then you should use the N data types.. eg nvarchar or nchar
otherwise just use the standard data types.
for language specific sorting and comparisons of the strings you need to select the correct colation.
Also some languages require that you have installed the language packs in windows for the characters to be visible in ssms.
November 9, 2011 at 7:17 am
Thanks but can you please any example..
November 9, 2011 at 7:19 am
bipan (11/9/2011)
Thanks but can you please any example..
example of what?
you have not stated which language you require and what datatype you need depends on the language's characters.
November 9, 2011 at 7:27 am
how to go for Chinese language.
November 9, 2011 at 7:33 am
Chinese (Macao SAR)
Chinese_Traditional_Pinyin_100_
Chinese (Macau)
Chinese_Traditional_Stroke_Order_100_
Chinese (Singapore)
Chinese_Simplified_Stroke_Order_100_
Windows Collation Name (Transact-SQL)
November 9, 2011 at 7:35 am
use N datatype (nvarchar,nchar, ntext)
if you need sorting and comparisons in Chinese then select which colaiton suits your Chinese lanugage and make this the colation of the the column or database.,
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply