From 79e13307cecb9326749b12910e12da5a9cddcb5e Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 26 Oct 2022 15:14:21 +0200
Subject: [inc/Database] Force utf8mb4 explicitly via SET NAMES

Apparently, putting &charset=utf7mb4 in the connect string is not enough
for reasons unknown to me.
---
 inc/database.inc.php | 1 +
 1 file changed, 1 insertion(+)

(limited to 'inc')

diff --git a/inc/database.inc.php b/inc/database.inc.php
index b326fbe4..ba6b58f8 100644
--- a/inc/database.inc.php
+++ b/inc/database.inc.php
@@ -30,6 +30,7 @@ class Database
 			self::$dbh = new PDO(CONFIG_SQL_DSN, CONFIG_SQL_USER, CONFIG_SQL_PASS, [
 				PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
 				PDO::ATTR_EMULATE_PREPARES   => true,
+				PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4', // Somehow needed, even if charset=utf8mb4 is in DSN?
 			]);
 		} catch (PDOException $e) {
 			if (self::$returnErrors)
-- 
cgit v1.2.3-55-g7522