Create unicode mb4 database

Thomas Mak wrote at 2020-11-11.

#mysql

The default unicode MySQL database does not work well with emoji. If you want to store emojis inside MySQL tables, the collate need to be `utf8mb4`, which stands for 4-Byte UTF-8 Unicode Encoding.

CREATE DATABASE db_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Comments

no comments yet.