From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Collation and Unicode support

Collation and Unicode support - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Collation and Unicode support

- [Instructor] When we consider collation and Unicode support in SQL Server, it was one of the aspects we talked about during the planning of the installation and understanding the installation options for SQL Server. We mentioned at the time that you choose your collation setting when you install SQL Server, and it was important to factor in the right collation, understanding that it affects the sorting rules, the case and accent sensitivity properties for the data. When we look at some of the data types that we use in SQL Server, a couple of the most common are the char and the varchar data types that we use in SQL, and those represent character data, and those are represented internally by character codes. So your chosen collation dictates those specific character codes and the supported characters that your database is able to understand. We also have support for Unicode in SQL Server, and there's a recommendation that if you're going to need Unicode support, and chances are you…

Contents