Store filenames with emoticons: Difference between revisions
From LogicalDOC Community Wiki
Jump to navigationJump to search
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..." |
No edit summary |
||
| Line 2: | Line 2: | ||
Execute the following SQL statements on the relevant field of the tables: ld_document, ld_version, ld_history | Execute the following SQL statements on the relevant field of the tables: ld_document, ld_version, ld_history | ||
<pre> | |||
ALTER TABLE | ALTER TABLE | ||
ld_document | ld_document | ||
| Line 24: | Line 24: | ||
CHARACTER SET utf8mb4 | CHARACTER SET utf8mb4 | ||
COLLATE utf8mb4_unicode_ci; | COLLATE utf8mb4_unicode_ci; | ||
</pre> | |||
Revision as of 09:29, 18 September 2019
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;
