From 3f91822784bb5650dee2d46daac9b1a21dd6b545 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sat, 12 Jun 2021 21:02:14 +0200
Subject: Encoding fixes for SQL dumps

---
 dumps/load-dumps.sh | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'dumps')

diff --git a/dumps/load-dumps.sh b/dumps/load-dumps.sh
index a94f500..a365c16 100755
--- a/dumps/load-dumps.sh
+++ b/dumps/load-dumps.sh
@@ -2,7 +2,7 @@
 pushd $(dirname $0) >> /dev/null
 grep -v '^#' .mapping | while read DB DUMP
 do
-    grep -v 'CREATE DATABASE' $DUMP | grep -vi '^Use ' | mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB
+    grep -v 'CREATE DATABASE' $DUMP | grep -vi '^Use ' | sed 's/SET NAMES cp1250/SET NAMES utf8mb4/g' | mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB
     if [[ $(mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB -N -e "SELECT language FROM params;") == *"english.language"* ]]
     then
         <logoh.en.sql mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB
-- 
cgit v1.2.3