Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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:

Community Additions

© 2015 Microsoft