docker-compose setup + mysql doesn't support articles with emojis about docker HOT 4 OPEN

@pixelyo, when you are using MySQL you need to use utf8mb4.

If you are using docker-compose use the example in this issue: #105

I've changed my docker-compose file after upgrading to the 2.3.2. It migrated the database without issues (Just make a backup to be on the save side :-) )

from docker.

@glego thanks, works :)

from docker.

wallabag in docker container seems to have a problem with the emoji in the content of the article. The thumbs up and cake is the problem. Error message is SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x91\x8D</...' for column 'content' at row 1

and thumbs's UTF-8 (hex) is 0xF0 0x9F 0x91 0x8D.

With mysql, there is always a problem, that default table encoding is utf8, but you need utf8mb. I do not know how this is in Mariadb, but maybe it's the same issue?

from docker.

Setting up the Database to be UTF8 has the solution, but i do not know how to integrate it into wallabag docker setup.

Or just use postgresql :)

from docker.