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 --- src/server/database/Database/MySQLConnection.cpp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/server/database/Database/MySQLConnection.cpp') diff --git a/src/server/database/Database/MySQLConnection.cpp b/src/server/database/Database/MySQLConnection.cpp index 994c532b4c5..f36f9d93fd3 100644 --- a/src/server/database/Database/MySQLConnection.cpp +++ b/src/server/database/Database/MySQLConnection.cpp @@ -99,7 +99,7 @@ uint32 MySQLConnection::Open() char const* unix_socket; //unsigned int timeout = 10; - mysql_options(mysqlInit, MYSQL_SET_CHARSET_NAME, "utf8"); + mysql_options(mysqlInit, MYSQL_SET_CHARSET_NAME, "utf8mb4"); //mysql_options(mysqlInit, MYSQL_OPT_READ_TIMEOUT, (char const*)&timeout); #ifdef _WIN32 if (m_connectionInfo.host == ".") // named pipe use option (Windows) @@ -168,7 +168,7 @@ uint32 MySQLConnection::Open() // set connection properties to UTF8 to properly handle locales for different // server configs - core sends data in UTF8, so MySQL must expect UTF8 too - mysql_set_character_set(m_Mysql, "utf8"); + mysql_set_character_set(m_Mysql, "utf8mb4"); return 0; } else -- cgit v1.2.3