Post reply

Multi language support in SQL Server 2008 R2

  • November 9, 2011 at 6:46 am

    #245913

    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

    #1405135

    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

    #1405153

    Thanks but can you please any example..

  • November 9, 2011 at 7:19 am

    #1405154

    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

    #1405162

    how to go for Chinese language.

  • November 9, 2011 at 7:33 am

    #1405171

    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

  • November 9, 2011 at 7:35 am

    #1405174

    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