MySQL Globalization

Abstract

This is the MySQL Globalization extract from the MySQL 5.7 Reference Manual.

For legal information, see the Legal Notices.

For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2024-12-24 (revision: 80591)

---

Table of Contents

Preface and Legal Notices

1 Character Sets, Collations, Unicode

1.1 Character Sets and Collations in General

1.2 Character Sets and Collations in MySQL

1.2.1 Character Set Repertoire

1.2.2 UTF-8 for Metadata

1.3 Specifying Character Sets and Collations

1.3.1 Collation Naming Conventions

1.3.2 Server Character Set and Collation

1.3.3 Database Character Set and Collation

1.3.4 Table Character Set and Collation

1.3.5 Column Character Set and Collation

1.3.6 Character String Literal Character Set and Collation

1.3.7 The National Character Set

1.3.8 Character Set Introducers

1.3.9 Examples of Character Set and Collation Assignment

1.3.10 Compatibility with Other DBMSs

1.4 Connection Character Sets and Collations

1.5 Configuring Application Character Set and Collation

1.6 Error Message Character Set

1.7 Column Character Set Conversion

1.8 Collation Issues

1.8.1 Using COLLATE in SQL Statements

1.8.2 COLLATE Clause Precedence

1.8.3 Character Set and Collation Compatibility

1.8.4 Collation Coercibility in Expressions

1.8.5 The binary Collation Compared to _bin Collations

1.8.6 Examples of the Effect of Collation

1.8.7 Using Collation in INFORMATION_SCHEMA Searches

1.9 Unicode Support

1.9.1 The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)

1.9.2 The utf8mb3 Character Set (3-Byte UTF-8 Unicode Encoding)

1.9.3 The utf8 Character Set (Alias for utf8mb3)

1.9.4 The ucs2 Character Set (UCS-2 Unicode Encoding)

1.9.5 The utf16 Character Set (UTF-16 Unicode Encoding)

1.9.6 The utf16le Character Set (UTF-16LE Unicode Encoding)

1.9.7 The utf32 Character Set (UTF-32 Unicode Encoding)

1.9.8 Converting Between 3-Byte and 4-Byte Unicode Character Sets

1.10 Supported Character Sets and Collations

1.10.1 Unicode Character Sets

1.10.2 West European Character Sets

1.10.3 Central European Character Sets

1.10.4 South European and Middle East Character Sets

1.10.5 Baltic Character Sets

1.10.6 Cyrillic Character Sets

1.10.7 Asian Character Sets

1.10.8 The Binary Character Set

1.11 Restrictions on Character Sets

1.12 Setting the Error Message Language

1.13 Adding a Character Set

1.13.1 Character Definition Arrays

1.13.2 String Collating Support for Complex Character Sets

1.13.3 Multi-Byte Character Support for Complex Character Sets

1.14 Adding a Collation to a Character Set

1.14.1 Collation Implementation Types

1.14.2 Choosing a Collation ID

1.14.3 Adding a Simple Collation to an 8-Bit Character Set

1.14.4 Adding a UCA Collation to a Unicode Character Set

1.15 Character Set Configuration

1.16 MySQL Server Locale Support

2 MySQL Server Time Zone Support