From 9b04009a35cf6e9cc4874aaa95ff2ca9708019ed Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 1 Feb 2023 22:18:31 +0300
Subject: Fix emoji collation issue on MariaDB

---
 src/main/resources/schema-mysql.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/main/resources/schema-mysql.sql')

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,
-- 
cgit v1.2.3

