diff options
| author |  Vitaly Takmazov | 2023-02-01 22:18:31 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-02-01 22:19:14 +0300 |
| commit | 9b04009a35cf6e9cc4874aaa95ff2ca9708019ed (patch) | |
| tree | 843a1c435509674e80b9aca84874052e26a0582f /src/main/resources | |
| parent | 57222853c90b0ffc4b800adeeddc289d58ee0a25 (diff) | |
Fix emoji collation issue on MariaDB
Diffstat (limited to 'src/main/resources')
| -rw-r--r-- | src/main/resources/schema-mysql.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/main/resources/schema-mysql.sql b/src/main/resources/schema-mysql.sql index 5b22bb35..0f6321fd 100644 --- a/src/main/resources/schema-mysql.sql +++ b/src/main/resources/schema-mysql.sql @@ -514,7 +514,7 @@ DROP TABLE IF EXISTS `tags`; CREATE TABLE `tags` ( `tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `synonym_id` int(10) unsigned DEFAULT NULL, - `name` char(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, + `name` char(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `notop` tinyint(1) unsigned NOT NULL DEFAULT 0, `noindex` tinyint(1) unsigned NOT NULL DEFAULT 0, `stat_messages` int(10) unsigned NOT NULL DEFAULT 0, |