What are collation settings?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are collation settings?
Rating:
Collation settings are fundamental to the structure and working of SQL Server 2005 databases. They include character set, sort order, and other locale-specific settings. Many server-to-server activities can fail or yield inconsistent results if collation settings are not consistent across servers. Collation settings can be applied to the server, database, column, or expression level.
Rating:
Was this information helpful?
Other articles
- What is double hop?
- What is index fragmentation?
- What is RAID-10?
- What is the sql_variant datatype?
- Study tips for Microsoft test 70-229.