Store filenames with emoticons

You must have a MySQL 5.7-8/MariaDB database with utf8md4 settings

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

Update the configuration of LogicalDOC
First you have to add a couple of parameters to the jdbc connection url of LogicalDOC
 * 1) Shutdown LogicalDOC system service/daemon
 * 2) Locate the file context.properties in /conf
 * 3) Edit the file context.properties by adding a couple of parameters to the value of key jdbc.url
 * 4) Locate the key jdbc.url and add the parameters characterEncoding=utf8&allowPublicKeyRetrieval=true  e.g.: jdbc.url=jdbc:mysql://localhost:3306/logicaldoc?useSSL=false&characterEncoding=utf8&allowPublicKeyRetrieval=true
 * 5) Save the file and restart LogicalDOC system service/daemon

Update the database schema
Connect to the database using mysql client mysql -u root -p logicaldoc

Check the status of the charset settings are OK with the query below



Here you should check that character_set_server is set to utf8mb4 If it is not set to utf8mb4 you must backup the database schema of logicaldoc and change that For more information utf8mb4 in MySQL Workbench and JDBC

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