From 6e4329b110b8efb428b13443063e0e28ac8ec536 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
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

