Loading

How to configure MySQL to support full Unicode?

Julkaisupäivä: Apr 24, 2025
Tehtävä
How to configure MySQL to support full Unicode?
Vaiheet
To support full Unicode in MySQL, the utf8mb4 encoding support is required.

Step 1 
Upgrade/install MySQL Server 5.5.3 or higher. MySQL 5.5.3 adds support for utf8mb4 character set which is required for some Unicode characters which use 4 bytes.

Step 2
Upgrade/install MySQL driver 5.3.11 or higher.
MySQL Connector/ODBC 5.3.11 release notes stated "The Unicode version now uses the utf8mb4 character set as a transport character set between the MySQL server and the ODBC driver.

Step 3
Set the encoding to utf8mb4 in MySQL server.
Please follow the instructions in How to support full Unicode in MySQL databases 
Lisäresurssit
Some of the Unicode characters e.g. emoji use 4 bytes instead of 3 bytes and utf8mb4 encoding/character set is needed.
Knowledge-artikkelin numero

001456934

 
Ladataan
Salesforce Help | Article