From the course: Learning phpMyAdmin

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Collation, character sets, and storage

Collation, character sets, and storage

From the course: Learning phpMyAdmin

Start my 1-month free trial

Collation, character sets, and storage

“

- Choosing collation in phpMyAdmin affects both the character set and the amount of storage space MySQL-compatible databases require for text-related columns. Character sets are closely related to collation. The character set specifies the encoding and range of available characters, while collation determines the sort order. In MySQL and related databases, character set and collation can be set independently at the database, table, or column level. There's nothing stopping you from defining tables with different character sets within the same database. You can even have columns in the same table with different character sets. The character set is implicit in the first part of the collation name. So phpMyAdmin kills two birds with one stone, and uses the selected collation to specify the character set. The default collation in mySQL is latin1_swedish_ci. The first part of the name, up to the first underscore, is the character set, latin1. This contains the basic ASCII set of…

Contents