Setting and Changing Collations
SQL Server 2005 collations can be specified at any level. When you install an instance of SQL Server 2005, you specify the default collation for that instance. Each time that you create a database, you can specify the default collation used for the database. If you do not specify a collation, the default collation for the database is the default collation for the instance. Whenever you define a character column, variable, or parameter, you can specify the collation of the object. If you do not specify a collation, the object is created by using the default collation of the database.
The following topics explain how to work with collations at the server, database, column, expression, and identifier levels:
- Setting and Changing the Server Collation
- Setting and Changing the Database Collation
- Setting and Changing the Column Collation
- Setting Expression Collation
- Identifier Collation