Good Afternoon,
I am having some troubles saving emojis in my database. I've added the utf8mb4 to my database connection...
When i try to add a note for example and it contains an emoji it shows me this message:
Anyone has been trough this?
Thanks,
Rodrigo
Which mysql version you are using? It should be greater than 5.5.3
Maybe this can help?
Yes, i've added the "utf8mb4" to my database connection.
But it doesn't work. I'll search more.
Don’t forget your db needs a characterset AND collation that supports emoji. Something like utf8mb4_unicode_ci. Having those with your modified connection string should work.
What you mean by collation? Sorry to ask.
Character Set determines which characters may be stored in the db/table/column.
Collation is how those characters are ordered and compared.
Both need to support utf8mb4, as well as the connection TO the db (which you’ve done.)
Use google/ai to find which character set and collation is best for your use case and db version.
Thanks man! Appreciate it!