How Can I Fix Character Set Errors When A Summernote Textarea Value is Saved To The Database?

[Antony]

Thanks to the forum’s auto-bump feature, this article came up today which answers everything!

My issues were

1. The column was set to utf8mb4 but the database wasn’t
2. The global database connection wasn’t set to be utf8mb4.

With step 2, remember to set it for each of your targets!

How to easily change the charset of your database tables with Wappler (to save emojis, and more!)

Hello there Here is a little tutorial to show you how you can easily change the charset of your database and your tables by using the terminal available in Wappler. Actually you can use the same method to connect to your database and do more things than just converting the charset to another one! In this example, we use Docker and we want to be able to save emojis in our database. If your database table is not using the right charset (utf8mb4), it won’t work and you’ll certainly see th…