-
Notifications
You must be signed in to change notification settings - Fork 22
Some emoji can't be used in items or action items for MySQL installations #362
Comments
This is also a problem in our company. We're trying to migrate away from PostgreSQL.
|
I made some progress on the service side...
see https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html and https://docs.pivotal.io/p-mysql/2-10/change-default.html#character Now when installing the app and checking the DB, all the tables have been correctly set up with utf8mb4, including the columns like "description":
And I can manually insert en emoji by running the INSERT statement that the app failed to execute, like:
Still, the character appears as "?" in the postfacto UI. And I can't insert an emoji from the app, it still gives a 500 with the same error as before in the logs. So I "patched" the app by adding the following to the production:
encoding: utf8mb4
collation: utf8mb4_unicode_ci I pushed the app again, and voilà, postfacto is working with emojis. The DB setup is clean, now is there a better way to make the app use the mysql utf8mb4 encoding (like with env vars or a different service config) rather than patching the database.yml file? |
TL;DR:
In the Postfacto sources, add this to the production:
encoding: utf8mb4
collation: utf8mb4_unicode_ci Push app... emojis should be working. CC @textbook if you're still searching for a solution/workaround. |
Steps to recreate:
bananas 🍌
)POST /api/retros/:slug/items
orPOST /api/retros/:slug/action_items
retro_reducer.js:78 Uncaught (in promise) TypeError: Cannot read property 'id' of undefined
This seems like a common problem for Rails-on-MySQL: https://stackoverflow.com/q/22464011/3001761
The text was updated successfully, but these errors were encountered: