I need to store central european characters eg Slovenian in my SQL Server 2000 database as well as English and western european characters. Am I right in thinking that using the default SQL_Latin1_General_CP1_CI_AS collation won't do the trick ? which collations do support central european characters ? I think SQL_Latin1_General_CP1250_CI_AS does support central european but are there any other options ?
what I don't really understand is how to choose which collation to use because what I really want to be able to do is store characters from any language in my database. if I wanted to store translations from every language in my database is there one collation that can do that ? eg I'll probably need to store chinese as well at some stage. do I need to have a number of different databases with different collations to support all languages? if so, what different collations would I need for that ?