Emoji trouble [??? Instead of emoji] Directus v9.7 #12287
Replies: 7 comments 5 replies
-
Are you 100,000% sure your database and all tables/columns are utf8mb4? If emoji's are saved as |
Beta Was this translation helpful? Give feedback.
-
|
100% and I try to set DB_CHARSET="utf8mb4" does not work... |
Beta Was this translation helpful? Give feedback.
-
|
And — yes this is an obvious question, but — your directus instance is connected to this exact database? It has to be a collation/charset problem in the database connection or database itself, as that's the only point at which emoji's might be converted to |
Beta Was this translation helpful? Give feedback.
-
|
100% directus instance is connected to exact database |
Beta Was this translation helpful? Give feedback.
-
|
Problem with read\write from directus, so this is connection problem DB_CONNECTION_STRING="mysql://u:pass@127.0.0.1/backendd?debug=false&charset=utf8mb4" also does not work |
Beta Was this translation helpful? Give feedback.
-
|
Have you tried using the individual env vars with the charset? So instead of the connection string, use |
Beta Was this translation helpful? Give feedback.
-
|
I connected in many ways, in general everything works, except for emojis Another example As you can see, some emojis have been saved normally SO! It's 100% connection problem, not in database I think DB_CHARSET does not work |
Beta Was this translation helpful? Give feedback.
-
|
DB_CHARSET="utf8mb4" does not work My .env DB_CLIENT="mysql" |
Beta Was this translation helpful? Give feedback.
-
|
I tried to reinstall on different hosting - it did not help, there is a problem |
Beta Was this translation helpful? Give feedback.
-
|
Using a totally fresh container from When setting
|
Beta Was this translation helpful? Give feedback.
-
|
If I add the following line to the .env file: DB_CHARSET="utf8mb4_unicode_ci" it works fine. But I receive the following warning on startup: I changed the database default charset to utf8mb4_unicode_ci and all tables and columns to utf8mb4_unicode_ci. I still receive the above warning. If I remove the DB_CHARSET="utf8mb4_unicode_ci" line, the emoji doesn't work any more. |
Beta Was this translation helpful? Give feedback.
-
|
Heya! Thank you for taking the time to submit this request! It has been over 90 days, and this discussion has not received at least 15 votes from the community. This means that we don't feel like there's enough community interest to warrant further R&D into this topic at this time. 🧊 This request will now be closed to keep our discussions tidy. Please reach out if you have any questions! For more information, see our Feature Request Process. |
Beta Was this translation helpful? Give feedback.
-
When I try to add emoji, I got in panel ??? Instead of 🚀.
I carefully read all the solutions that were previously suggested and nothing helps.
I tried to play with DB_CHARSET="utf8mb4"
I tried to play with DB_CONNECTION_STRING="mysql://u:p@127.0.0.1/d?debug=false&charset=UTF8MB4"
(Of course I have tried everything with utf8mb4_unicode_ci, utf8mb4_general_ci etc)
Nothing helped. My database 100% utf8mb4, when I connect with client to my database and use Client Character Set "utf8mb4" encoding "utf-8" and my database, table, column are utf8mb4 utf8mb4_unicode_ci I see everything fine.
When I add emoji in database directly in panel, I got only one ? in panel
I've been fighting for these emojis all day and going crazy.
Help)
To Reproduce
Just try to add emoji in panel
What version of Directus are you using?
9.7
What database are you using?
MariaDB 10.5.15
Beta Was this translation helpful? Give feedback.
All reactions