If all users of your instance of SQL Server speak the same
language, you should pick the collation that supports that
language. For example, if all users speak French, select a
French collation. If the users of your instance of SQL Server
speak different languages, you should pick a collation that best
supports the requirements of the various languages. For example,
if the users generally speak western European languages, choose
Latin1_General collation. When you support users who speak
different languages, it is most important to use the Unicode
data types nchar, nvarchar, and nvarchar(max) for all character
data. Unicode avoids the code page conversion difficulties of
the non-Unicode char, varchar, and text data types. Collation
still makes a difference when you implement all columns using
Unicode data types, because it defines the sort order for
comparisons and the sorts of Unicode characters. Even when you
store your character data using Unicode data types, you should
pick a collation that supports most o