Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem with charset if use of emojis #15

Open
polymeer opened this issue Jun 22, 2018 · 0 comments
Open

Problem with charset if use of emojis #15

polymeer opened this issue Jun 22, 2018 · 0 comments

Comments

@polymeer
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant