CODEWITHSUNDEEP
sql-servercollation
Itay.B
Itay.B

Reputation: 4111

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 I do it?

Thanks

Upvotes: 1

Views: 599

Answers (2)

DataWriter
DataWriter

Reputation: 1040

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.

Upvotes: 1

Vidar Nordnes
Vidar Nordnes

Reputation: 1364

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

Upvotes: 2

Related Questions