SQL Collation to support all European Languages plus Russian Cyrillic

is it possible to have a collation on a table? I build a multi tenancy app and don't want for each country to hav开发者_开发知识库e an extra database because the collation is different. I use SQL Server 2008 R2 if this makes any difference.

---

You need to use nvarchar. You won't be able to store multiple alphabets in varchar

Collation is code page for non-unicode data, and sorting and comparison for both. But you're still limited to 8 bit ASCII in the specified code page.

You could have different tables for each character set/alphabet, say on a 1 to 1 with some parent entity table. However, nvarchar is simpler unless you plan on having terabytes of text where the overhead is better than wide data.

Edit: my mistake, collation is always sorting and comparison.