Multi language support in SQL Server 2008 R2

  • 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

  • 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.

  • Thanks but can you please any example..

  • 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.

  • how to go for Chinese language.

  • 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)

    http://msdn.microsoft.com/en-us/library/ms188046.aspx

  • 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.,

    http://msdn.microsoft.com/en-us/library/ms143508.aspx

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply