Chapter 17. Character Sets and Collating Sequences


In this book, the concepts character sets and collating sequence have been mentioned a few times. What these concepts exactly mean and how SQL handles them is the topic of this chapter.


In the various SQL products, support for character sets and collating sequences has been implemented very differently. For that reason, we describe the form implemented in MySQL.

To store alphanumeric values, characters such as A, b, and ë, but also special symbols such as {, &, and =, they must be converted into numeric codes. Something like a translation table must be built that contains a unique numeric code for each relevant character. Each character, therefore, gets a position in that ...

Get Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.