Loading

How to configure MySQL to support full Unicode?

Veröffentlichungsdatum: Apr 24, 2025
Aufgabe
How to configure MySQL to support full Unicode?
Schritte
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 
Zusätzliche Ressourcen
Some of the Unicode characters e.g. emoji use 4 bytes instead of 3 bytes and utf8mb4 encoding/character set is needed.
Nummer des Knowledge-Artikels

001456934

 
Laden
Salesforce Help | Article