From the course: Developing Microsoft SQL Server 2016 Databases
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Understand column collation - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Understand column collation
- [[Instructor] Here's a question for you to think about. When sorting records in a table, does a record starting with a capital A come before or after a record starting with a lowercase A? Does the number one come before or after the letter A? It might not be something that you think about, but different countries prefer to sort information in different ways. SQL Server defaults to sorting records based on the localization of the machine that the server is installed on. If you work for an international organization and transfer a database to a server in another country, you might be surprised that the queries begin returning values slightly differently. This is due to something called collation. Collation controls the sort order of items in a database, as well as the case sensitivity of the system. If the collation is case sensitive, then the uppercase letters are treated differently than the lowercase letters. Objects can also be set to accent sensitive, in which case letters with…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.