Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Explore the introduction of UTF-8 support in SQL Server 2019 through this comprehensive conference talk. Delve into the evolution of Unicode support in SQL Server, from UCS-2 encoding to UTF-16, and now UTF-8. Understand the potential performance benefits and compatibility improvements offered by the new Supplementary Character "_UTF8" feature. Learn about different string data types, collations, supplementary characters, surrogate pairs, code pages, and various encoding methods including ASCII, Unicode, UCS-2, UTF-16, and UTF-8. Gain insights into the proper implementation of UTF-8 to avoid unwanted implications and optimize data storage. Discover how SQL Server internally stores and utilizes data, with a special focus on emoji support. By the end of this talk, acquire a deep understanding of SQL Server's string handling capabilities and how to leverage UTF-8 for enhanced performance and compatibility in your database systems.
