docker-compose setup + mysql doesn't support articles with emojis

[pixelyo]

i am using the wallabag docker-compose setup. I am receiving a 500: Internal Server Error when I try to bag this page: https://blog.kentcdodds.com/how-getting-into-open-source-has-been-awesome-for-me-8480cd756a80

I get this error from the browser addon, web application, and android app.

here is the full error message from web application - error message as picture

android app error message:

Server error
Error: com.di72nn.stuff.wallabag.apiwrapper.exceptions.UnsuccessfulResponseException: HTTP response: 500 Internal Server Error

another user maybe had a similar issue and the article he tried to bag gets me also the error described above.

is this maybe a related issue?

posted about it yesterday, but with too little information and probably in the wrong repo

can you help me with this problem?

[Strubbl]

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?

[Strubbl]

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 :)

[glego]

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

If you are using docker-compose use the example in this issue: https://github.com/wallabag/docker/issues/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 :-) )

[pixelyo]

@glego thanks, works :)