From the course: SQL Server Performance for Developers
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Unicode data - SQL Server Tutorial
From the course: SQL Server Performance for Developers
Unicode data
- [Instructor] Let's talk about Unicode data. Unicode data is an ISO, or International Standards Organization specification for a methodology of storing data that takes more than one byte to persist. You may ask, what type of data would take more than one byte to persist? Well, certain types of languages, for example, Cyrillic, and other Asian languages that have enhanced characters or symbols to represent words, that data requires more than one type. When we talk about regular data types, they only store one byte per character, and we are limited in the amount of data that can be transferred. Unicode is also, as I mentioned, an ISO standard, and it's a single encoding system that's used widely around the world. What this means is all characters will consistently translate those bit patterns from Unicode data into characters based on that specification. Data can be freely transferred from one database or computer to another without worrying about data type mismatches. However, we have…
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.