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