Store filenames with emoticons

You must have a MySQL/MariaDB database with utf8md4 settings

Since this is not a risk-free operation it is necessary to back up the database before proceeding.

Connect to the database using mysql client

mysql -u root -p logicaldoc

Execute the following SQL statements on the relevant field of the tables: ld_document, ld_version, ld_history

 1 ALTER TABLE
 2     ld_document
 3     CHANGE ld_filename ld_filename
 4     VARCHAR(255)
 5     CHARACTER SET utf8mb4
 6     COLLATE utf8mb4_unicode_ci;
 7 
 8 ALTER TABLE
 9     ld_version
10     CHANGE ld_filename ld_filename
11     VARCHAR(255)
12     CHARACTER SET utf8mb4
13     COLLATE utf8mb4_unicode_ci;
14 
15 
16 ALTER TABLE
17     ld_history
18     CHANGE ld_filename ld_filename
19     VARCHAR(255)
20     CHARACTER SET utf8mb4
21     COLLATE utf8mb4_unicode_ci;