oliviermaridat/kanboard-sqlite2mysql

Problem with charset if use of emojis

polymeer opened this issue · 0 comments

At first: Good job dude! I would lost without this script.

I've migrate a sqlite db with actual git version of kanboard but with interupt.

ERROR 1366 (22007) at line 1157: Incorrect string value: '\xF0\x9F\x91\x8D\x0A-...' for column 'comment' at row 1

Problem is this emoji: 👍

I've changed the charset of mysql database to utf8mb4_bin. That works until the migration is already done but not for the migration itselve.
Fortunately I had just two of that chars in my projects so I could change them before migration. When kanboard is running with mysql connection you can add emojis in your comments.

Cheers Tino