Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 8.4 Reference Manual
Preface and Legal Notices
General Information
Installing MySQL
Upgrading MySQL
Downgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Character Sets and Collations in General
Character Sets and Collations in MySQL
Character Set Repertoire
UTF-8 for Metadata
Specifying Character Sets and Collations
Collation Naming Conventions
Server Character Set and Collation
Database Character Set and Collation
Table Character Set and Collation
Column Character Set and Collation
Character String Literal Character Set and Collation
The National Character Set
Character Set Introducers
Examples of Character Set and Collation Assignment
Compatibility with Other DBMSs
Connection Character Sets and Collations
Configuring Application Character Set and Collation
Error Message Character Set
Column Character Set Conversion
Collation Issues
Using COLLATE in SQL Statements
COLLATE Clause Precedence
Character Set and Collation Compatibility
Collation Coercibility in Expressions
The binary Collation Compared to _bin Collations
Examples of the Effect of Collation
Using Collation in INFORMATION_SCHEMA Searches
Unicode Support
The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)
The utf8mb3 Character Set (3-Byte UTF-8 Unicode Encoding)
The utf8 Character Set (Deprecated alias for utf8mb3)
The ucs2 Character Set (UCS-2 Unicode Encoding)
The utf16 Character Set (UTF-16 Unicode Encoding)
The utf16le Character Set (UTF-16LE Unicode Encoding)
The utf32 Character Set (UTF-32 Unicode Encoding)
Converting Between 3-Byte and 4-Byte Unicode Character Sets
Supported Character Sets and Collations
Unicode Character Sets
West European Character Sets
Central European Character Sets
South European and Middle East Character Sets
Baltic Character Sets
Cyrillic Character Sets
Asian Character Sets
The cp932 Character Set
The gb18030 Character Set
The Binary Character Set
Restrictions on Character Sets
Setting the Error Message Language
Adding a Character Set
Character Definition Arrays
String Collating Support for Complex Character Sets
Multi-Byte Character Support for Complex Character Sets
Adding a Collation to a Character Set
Collation Implementation Types
Choosing a Collation ID
Adding a Simple Collation to an 8-Bit Character Set
Adding a UCA Collation to a Unicode Character Set
Defining a UCA Collation Using LDML Syntax
LDML Syntax Supported in MySQL
Diagnostics During Index.xml Parsing
Character Set Configuration
MySQL Server Locale Support
Data Types
Functions and Operators
SQL Statements
MySQL Data Dictionary
The InnoDB Storage Engine
Alternative Storage Engines
Replication
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
InnoDB ReplicaSet
MySQL NDB Cluster 8.4
Partitioning
Stored Objects
INFORMATION_SCHEMA Tables
MySQL Performance Schema
MySQL sys Schema
Connectors and APIs
MySQL Enterprise Edition
MySQL Workbench
MySQL on OCI Marketplace
Telemetry
MySQL 8.4 Frequently Asked Questions
Error Messages and Common Problems
Indexes
MySQL Glossary
Related Documentation
MySQL 8.4 Release Notes
Download this Manual
PDF (US Ltr)
- 40.0Mb
PDF (A4)
- 40.1Mb
Man Pages (TGZ)
- 259.1Kb
Man Pages (Zip)
- 366.2Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
version 8.4
9.1
9.0
8.0
5.7
8.0 Japanese
MySQL 8.4 Reference Manual
/
...
/
Character Sets, Collations, Unicode
/
Unicode Support
/
The utf16le Character Set (UTF-16LE Unicode Encoding)
12.9.6 The utf16le Character Set (UTF-16LE Unicode Encoding)
This is the same as
utf16
but is little-endian rather than big-endian.
PREV
HOME
UP
NEXT
Related Documentation
MySQL 8.4 Release Notes
Download this Manual
PDF (US Ltr)
- 40.0Mb
PDF (A4)
- 40.1Mb
Man Pages (TGZ)
- 259.1Kb
Man Pages (Zip)
- 366.2Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb