diff options
| author | Gildor <gildor55@gmail.com> | 2024-02-05 12:27:38 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-02-05 12:27:38 +0100 |
| commit | f647199e22a411a7822502ae15ffb6b4f9009bb9 (patch) | |
| tree | 2d6e6d2bdac691fb3b94605368e85cbbce64ea03 | |
| parent | e7ff4fe613e5b99b4e7c9553078d2947eabf7c07 (diff) | |
DB/Channels: Allow name to be accent-sensitive (#29668)
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/3.3.5/2024_02_05_00_characters.sql | 2 |
2 files changed, 5 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 5ad3440ed67..3a468396581 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -401,7 +401,7 @@ DROP TABLE IF EXISTS `channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `channels` ( - `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `team` int unsigned NOT NULL, `announce` tinyint unsigned NOT NULL DEFAULT '1', `ownership` tinyint unsigned NOT NULL DEFAULT '1', @@ -2683,7 +2683,8 @@ INSERT INTO `updates` VALUES ('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','ARCHIVED','2023-05-19 18:40:42',0), ('2023_06_14_00_characters.sql','0595B21DCFC0A04F2D8DF1F7BC018C758895DBE5','ARCHIVED','2023-06-14 19:34:24',0), ('2023_09_10_00_characters.sql','5DE09CA31B5168CF3622CB462816B6C598893D96','ARCHIVED','2023-09-10 12:23:34',0), -('2024_01_21_00_characters.sql','4D27D8DAC9F78795DB6938B54F32502EF8D8AAE6','ARCHIVED','2024-01-21 11:38:22',0); +('2024_01_21_00_characters.sql','4D27D8DAC9F78795DB6938B54F32502EF8D8AAE6','ARCHIVED','2024-01-21 11:38:22',0), +('2024_02_05_00_characters.sql','1777CBCA822AD85777DA4A390DF7AAF41AF68EBD','RELEASED','2024-02-05 12:17:19',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/3.3.5/2024_02_05_00_characters.sql b/sql/updates/characters/3.3.5/2024_02_05_00_characters.sql new file mode 100644 index 00000000000..875151eb350 --- /dev/null +++ b/sql/updates/characters/3.3.5/2024_02_05_00_characters.sql @@ -0,0 +1,2 @@ +-- +ALTER TABLE `channels` MODIFY `name` VARCHAR(128) NOT NULL COLLATE utf8mb4_bin; |