ILIAS-7-Install-Tutorial for Ubuntu 20.04

Change collation

Do not do this with your ILIAS DB! It needs utf8, not utf8mb4!

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
#!/bin/bash
 
DATABASE=some_db
 
#CHARACTER_SET=utf8
#COLLATE=utf8_unicode_ci
CHARACTER_SET=utf8mb4
COLLATE=utf8mb4_unicode_ci
 
TABLES=$(echo SHOW TABLES | mysql -s $DATABASE)
 
for TABLE in $TABLES ; do
    echo "ALTER TABLE $TABLE CONVERT TO CHARACTER SET $CHARACTER_SET COLLATE $COLLATE;"
    echo "ALTER TABLE $TABLE CONVERT TO CHARACTER SET $CHARACTER_SET COLLATE $COLLATE" | mysql $DATABASE
done


Information Message
No comment has been posted yet.