Content
View differences
Updated by Oliver Günther about 8 years ago
MySQL will allocate 3 bytes for utf8 collation, however most(?) emojis are actual 4-byte character sequences, so as a result, MySQL utf8 collation types will not fully support unicode.
There is a different collation utf8mb4 that supports it which you may want to try out: http://jasonseifer.com/2014/06/20/rails-4-mysql-and-emoji-mysql2error-incorrect-string-value-error
We may want to look further into this but it would involve a migration and proper testing that the conversion works properly.
Tickets for specific functionality where this happens
\#\#25392
\#\#25361
\#\#27081
There is a different collation utf8mb4 that supports it which you may want to try out: http://jasonseifer.com/2014/06/20/rails-4-mysql-and-emoji-mysql2error-incorrect-string-value-error
We may want to look further into this but it would involve a migration and proper testing that the conversion works properly.
Tickets for specific functionality where this happens
\#\#25392
\#\#25361
\#\#27081