|
Define Collation.- Collation is the order that SQL Server uses for sorting or comparing the textual data.
There are three types of sort order:
1. Dictionary case sensitive.
2. Dictionary case insensitive.
3. Binary.
- It encodes the rules governing the proper use of characters for either language.
- It is used to store non-Unicode character data.
- You cannot specify a collation for character variables and parameters.
|
