HOW TO BREAK THE GRIFPER'S HOUSE IN MINECRAFT A?

Question

Habr

I ASK YOU DO YOU UNDERSTAND OR NOT

Answer 1

# Для всей базы
ALTER DATABASE
    database_name
    CHARACTER SET = utf8mb4
    COLLATE = utf8mb4_unicode_ci;

# Для одной таблицы
ALTER TABLE
    table_name
    CONVERT TO CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

# Для одного поля таблицы
ALTER TABLE
    table_name
    CHANGE column_name column_name
    VARCHAR(191)
    CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

I would not advise putting utf8mb4 entirely on the entire database (on weak machines there will be a blockage) since this requires enough memory, it is better to change only the fields you need, mainly these are fields that can contain smilies, hieroglyphs and other non-standard strings

Answer 2

Need a special encoding (utf8mb4) for fields with emoji
https://ifmo.su/mysql-and-emoji