Store filenames with emoticons
From LogicalDOC Community Wiki
Jump to navigationJump to search
You 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;