Mladen Prajdić is a Data Platform MVP from Slovenia. He's been programming for 20 years, developing diﬀerent types of applications in .Net (C#), SQL Server, and Swift, ranging from standard line-of-business image-processing applications to high-performance and IoT applications. He's a regular speaker at various conferences and user group meetings and really likes optimizing slow SQL statements, analyzing performance, and finding unconventional solutions to complex SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
Thē wönderfűl wôrld of ćollåtions, eñcodingß and téxt sţoræge
The chances of having data in a single language are slim to none in today's world. Your customers speak and write many languages with many different letters. Once you get to talking or thinking about characters, collations, encodings, sort orders, diacritics, code pages, etc., a brain melt is what you end up with. In this session, we'll look at what all of these things are and how they fit together, and how to use them properly, as each can break your applications in various ways. Since SQL Server 2019 brought improvements in the UTF-8 area, we'll also look at that. Because sometimes it's not enough to just use NChar or NVarChar and think everything will be ok.