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
From the course: Learning phpMyAdmin
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Choosing the right column types6m 6s
-
(Locked)
Collation, character sets, and storage6m 2s
-
(Locked)
Defining a table8m 19s
-
(Locked)
Amending the table structure5m 55s
-
(Locked)
Inserting data manually5m
-
(Locked)
Using the Browse tab7m 21s
-
(Locked)
Copying a column definition to another table with central columns7m 24s
-
-
-
-
-
-
-