Error when using emojis on wiki pages

[jywarren]

Please describe the problem (or idea)

What happened just before the problem occurred? Or what problem could this idea solve?

I tried to save a wiki page edit using an emoji -- 🎉

But i got an error! The logs show:

"Mysql2::Error: Incorrect string value: \xF0\x9F\x8E\x89 \x0D... for column 'body' at row 1 on this line:

plots2/app/controllers/wiki_controller.rb

Line 170 in 3df8567

@revision.save

Any help appreciated! Emoji are important for showing appreciation to contributors 🥇 🎈 🎉

[ryzokuken]

@jywarren take a look at https://stackoverflow.com/a/22464749/5156578. This should solve our problem.

[namangupta01]

Does this problem also occur in development mode?

[jywarren]

I'm not sure, but i bet we could add a functional test for the wiki controller to see if we can reproduce this. It'll work in Travis since that uses mysql!

[jywarren]

I also wonder if this prior suggestion of a different encoding might help? #2209

[namangupta01]

Yes i also remember i commented on the issue to change the encoding but not able to find that issue.

[namangupta01]

got the issue...here it is #2665

[jywarren]

#3007

[jywarren]

Solved in unicode db!