O'Reilly logo

Sams Teach Yourself MySQL by Chris Newman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Character Sets and Collations

MySQL supports different character sets and collations to provide functionality for users who want to create database applications in different languages.

The character set determines how MySQL stores character data. Each letter in a character string is represented internally by a numeric value, and the character set determines the character mapping of each number.

A collation is a set of rules for comparing characters in a character set—essentially, it defines the alphabetical order for a character set. For instance, the character Ö in a German character set is usually treated as OE for ordering purposes.

Collation rules can also take into account case sensitivity. You saw in Lesson 7, “String Operators and Functions,” ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required