Best General Purpose Character Set and Collation for MySQL
9
votes
2
answers
16246
views
Currently, whenever I create a new MySQL database, I use utf8mb4 as a character set and utf8mb4_unicode_520_ci for the collation, e.g.:
CREATE DATABASE IF NOT EXISTS db_name
DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
Is there a newer/upgraded general purpose collation or character set for MySQL?
For example if there's a collation that superseded utf8mb4_unicode_520_ci, like utf8mb4_unicode_800_ci or something like that?
Thanks for your help.
Asked by GTS Joe
(273 rep)
Jun 2, 2021, 11:48 PM
Last activity: Mar 13, 2025, 11:03 AM
Last activity: Mar 13, 2025, 11:03 AM