Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

MySQL 4.1.x and Later


Since MySQL 4.1.x, the MySQL server does the character recoding work for us. Also, MySQL enables us to indicate the character set and collation for each database, each table, and even each field. A default character set for a database applies to each of its tables, unless it is overridden at the table level. The same principle applies to every field.

Since phpMyAdmin 2.6.0, support for MySQL 4.1.x character set and collation features is no longer experimental, as it was in previous versions.

The $cfg['AllowAnywhereRecoding'] parameter has no impact for MySQL version 4.1.x and later, except to enable the Character set of the file drop-down menu in the Export sub-page.

Collations

When strings have to be compared and sorted, precise rules must be followed by the system (MySQL, in this case). For example, is 'A' equivalent to 'a'? Is 'André' equivalent to 'Andre'? A set of these rules is called a collation.

A proper choice of collation is important for obtaining the...