【MySQL】絵文字を保存する

公開: 2024-07-16更新: 2026-05-16

sql

ALTER DATABASE `database_name`
DEFAULT CHARACTER SET utf8mb4
DEFAULT COLLATE utf8mb4_general_ci;

sql

ALTER TABLE table_name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE table_name DEFAULT CHARSET=utf8mb4;

sql

ALTER TABLE table_name MODIFY COLUMN column_name text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;

関連記事