A deep dive into MySQL collations triggered by emoji-related errors in production. Explores how collations control text comparison, sorting, and searching in databases, demonstrating through practical examples how collation mismatches can cause unexpected behavior in queries, indexes, joins, and deletions. Covers the evolution
•18m read time• From wix.engineering
Table of contents
IntroductionTaming the TextThe Rules of the Game: What Are Collations?The Collation LaboratoryNavigating the PitfallsDeletion: More Than You Asked ForUniqueness: They Are the Same ZebraIndexes: Now You See Me, Now You Don’tThe Trouble with JoinsProduction Story: Mismatched CollationsConclusionSort: