Store filenames with emoticons

From LogicalDOC Community Wiki
Revision as of 09:28, 18 September 2019 by Blucecio (talk | contribs) (Created page with "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 A...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;