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

Emoji (or Unicode in general) doesn't get imported #5519

Closed
blackxored opened this Issue Jul 5, 2015 · 3 comments

Comments

Projects
None yet
3 participants
@blackxored

blackxored commented Jul 5, 2015

I've exported my settings since I recently migrated from SQLite to RDS and emojis didn't get imported back.

Update: hmm is not only about the importing, it's also when I save them back, I wonder if there's a misconfiguration on my end? I've tried setting charset in the connection config, no luck.

@ErisDS

This comment has been minimized.

Member

ErisDS commented Jul 5, 2015

Hi @blackxored, sorry to hear you've had some trouble with exports & imports 😞. Can you please help us to fix the issue by providing a bit more detail? There's a bug report template in our contributing guidelines - it would be good to have the full details of the export & import environments, as well as an example JSON file that doesn't report properly.

If you can make it as easy as possible to reproduce the issue, it's far more likely to get fixed quickly. Thanks 😸

@blackxored

This comment has been minimized.

blackxored commented Jul 6, 2015

Hi, I think they might be an issue with my MySQL config, as I tried inserting an emoji to my about section and then saving, and while it seems to be in memory works, but as soon as I refresh a couple of times I'm back to ????, any clues?

@ErisDS ErisDS added the importer label Aug 9, 2015

@ErisDS ErisDS added the bug label Oct 9, 2015

@Kikobeats

This comment has been minimized.

Kikobeats commented Nov 13, 2015

@blackxored I have the same issue under Ghost@0.7 using twemoji (and MySQL as well)

the format of my MySQL database is utf8, if I check the markdown field:

trying emoji support!

???? ???? ????

emoji in line ????

References:

UPDATE1: I updated my database to change the format, and use a client option as:

charset: 'utf8mb4',

but not work :-(

UPDATE2:

  1. Follow the tutorial to update utf8 to utf8mb4 (I think that with post collection is enough).
  2. Use the last mysql dependency version (2.9.0 or above)
  3. In the client connection (in config.json) add charset: 'utf8mb4' as connection option.

works!

so more than a Ghost problem is a problem with the database charset. utf8mb4 by default could be nice.

kirrg001 added a commit to kirrg001/Ghost that referenced this issue Sep 20, 2016

0;95;0c# The first commit's message is:
  use utf8mb4 encoding

closes TryGhost#5519, closes TryGhost#6197

- default encoding is utf8mb4 instead of utf8
- support emojis
- read here why: http://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions.html
- read here why: https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-conversion.html

kirrg001 added a commit to kirrg001/Ghost that referenced this issue Sep 20, 2016

ErisDS added a commit that referenced this issue Sep 20, 2016

utf8mb4 support (#7409)
closes #5519, closes #6197

- default encoding is utf8mb4 instead of utf8
- support emojis
- read here why: http://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions.html
- read here why: https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-conversion.html

@ErisDS ErisDS closed this in 32a5982 Sep 20, 2016

mixonic added a commit to mixonic/Ghost that referenced this issue Oct 28, 2016

madfrog2047 added a commit to madfrog2047/Ghost that referenced this issue Nov 20, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment