Store filenames with emoticons
From LogicalDOC Community Wiki
Jump to navigationJump to searchYou must have a MySQL/MariaDB database with utf8md4 settings
Execute the following SQL statements on the relevant field of the tables: ld_document, ld_version, ld_history
ALTER TABLE ld_document CHANGE ld_filename ld_filename VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE ld_version CHANGE ld_filename ld_filename VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE ld_history CHANGE ld_filename ld_filename VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;