]> git.immae.eu Git - github/wallabag/wallabag.git/commit
mysql: change collation of tag table 3959/head
authorKevin Decherf <kevin@kdecherf.com>
Sat, 11 May 2019 18:07:38 +0000 (20:07 +0200)
committerKevin Decherf <kevin@kdecherf.com>
Sun, 19 May 2019 21:37:49 +0000 (23:37 +0200)
commitfeb239ea1006685ab3862c988309a1a5a9659559
tree034e26b367d06796a4f7888847cff76b1401ad7a
parentde1162b91a205a98a3f8ed01bd80285793b18380
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>
app/DoctrineMigrations/Version20190511165128.php [new file with mode: 0644]
src/Wallabag/CoreBundle/Entity/Tag.php
tests/Wallabag/CoreBundle/Controller/TagControllerTest.php