From 6e4329b110b8efb428b13443063e0e28ac8ec536 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 5 Feb 2023 14:58:07 +0100 Subject: DB: Convert databases to utf8mb4 --- sql/create/create_mysql.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'sql/create/create_mysql.sql') diff --git a/sql/create/create_mysql.sql b/sql/create/create_mysql.sql index c7a1b12cc27..4b68a2d7e65 100644 --- a/sql/create/create_mysql.sql +++ b/sql/create/create_mysql.sql @@ -2,11 +2,11 @@ CREATE USER 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_H GRANT USAGE ON * . * TO 'trinity'@'localhost'; -CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; +CREATE DATABASE `world` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; +CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -CREATE DATABASE `auth` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; +CREATE DATABASE `auth` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION; -- cgit v1.2.3