SQL Server generic Collation

I need to create a database in SQL Server, which will be able to support English, Hebrew and Arabic.

How can开发者_如何学Go I do it?

Thanks

Use nvarchar instead of varchar fields. The collation is mainly used for sorting

Take a look into how to use collations.(http://msdn.microsoft.com/en-us/library/ms144260.aspx)

SQL Server 2008 allows you to set the collation at the column level. This means, for example, you could have a product table with description columns in each language, English, Hebrew, and Arabic.