aboutsummaryrefslogtreecommitdiffhomepage
path: root/src/Wallabag
diff options
context:
space:
mode:
authorKevin Decherf <kevin@kdecherf.com>2019-05-11 20:07:38 +0200
committerKevin Decherf <kevin@kdecherf.com>2019-05-19 23:37:49 +0200
commitfeb239ea1006685ab3862c988309a1a5a9659559 (patch)
tree034e26b367d06796a4f7888847cff76b1401ad7a /src/Wallabag
parentde1162b91a205a98a3f8ed01bd80285793b18380 (diff)
downloadwallabag-feb239ea1006685ab3862c988309a1a5a9659559.tar.gz
wallabag-feb239ea1006685ab3862c988309a1a5a9659559.tar.zst
wallabag-feb239ea1006685ab3862c988309a1a5a9659559.zip
mysql: change collation of tag table
utf8mb4_unicode_ci considers that 'caché' is equal to 'cache' which can lead to attaching incorrect tags to entries. This issue is due to some unicode normalization done by MySQL. utf8mb4_bin makes no unicode normalization, letting wallabag to consider 'cache' and 'caché' as two different tags. We change the collation of the whole table as Doctrine does not support setting a collation on a column for a specific platform (it tries to apply utf8mb4_bin even for pgsql and sqlite). Fixes #3302 Signed-off-by: Kevin Decherf <kevin@kdecherf.com>
Diffstat (limited to 'src/Wallabag')
-rw-r--r--src/Wallabag/CoreBundle/Entity/Tag.php5
1 files changed, 4 insertions, 1 deletions
diff --git a/src/Wallabag/CoreBundle/Entity/Tag.php b/src/Wallabag/CoreBundle/Entity/Tag.php
index a6dc8c50..95c47bbd 100644
--- a/src/Wallabag/CoreBundle/Entity/Tag.php
+++ b/src/Wallabag/CoreBundle/Entity/Tag.php
@@ -13,7 +13,10 @@ use JMS\Serializer\Annotation\XmlRoot;
13 * Tag. 13 * Tag.
14 * 14 *
15 * @XmlRoot("tag") 15 * @XmlRoot("tag")
16 * @ORM\Table(name="`tag`") 16 * @ORM\Table(
17 * name="`tag`",
18 * options={"collate"="utf8mb4_bin", "charset"="utf8mb4"},
19 * )
17 * @ORM\Entity(repositoryClass="Wallabag\CoreBundle\Repository\TagRepository") 20 * @ORM\Entity(repositoryClass="Wallabag\CoreBundle\Repository\TagRepository")
18 * @ExclusionPolicy("all") 21 * @ExclusionPolicy("all")
19 */ 22 */