Sample Header Ad - 728x90

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