SQL Server Performance

MultiLanguage Problem

Discussion in 'General Developer Questions' started by mighty_man, Jun 18, 2003.

  1. mighty_man New Member

    I need to store text/html in a table(ms sql 2k). The text/html could be in german/polish/swedish
    so I have some trouble to choose a collation that could support this.

    Is there any collation that support all this ?

    Else

    What could be the best solution to store this, covert some chars, html encode ?

    please help

    peace.
  2. vbkenya New Member

    Contrary to popular opinion, those three languages have only one common shared character set called 'ISO 8859-13' or Latin-7. This set is composed of ASCII plus the accented characters needed for most Baltic languages including Latvian, Lithuanian, Estonian, and Finnish, as well as English, Danish, Swedish, German, Slovenian, and Norwegian.

    SQL server and Windows do not explicity provide this character set but it closely resembles CP1257 (WinBaltic). I think you can use any of the SQL CP1257 collations (Latvian,Estonian,Lithuanian,General_Latin1) for your storage.

    MUST READ:
    There is a very useful article on SQL 2000 International features at:

    http://msdn.microsoft.com/library/d...dnsql2k/html/intlfeaturesinsqlserver2000.asp]


    On character sets in general, check out

    http://www.cs.tut.fi/~jkorpela/8859.html#annex]

    Have fun.

    Nathan H.O.

Share This Page