Hello dear community
I have a challenge in an ongoing problem that I could not solve yet. I fill the NocoDB via API with data from forms . As part of the internationalization process, I am now adding form data from china written in simple chinese. Unfortunately, the Chinese characters cannot be saved. Therefore my question, which adjustments do I have to make and where, so that I can save the Chinese texts via the interface.
Solution:
change the charset of the database. I changed it from utf8 to utf8mb4. after that it worked just fine.
Important: it can happend that already existing entries in the database have mixed characters because they where added with a different charset.
To prevent you from data lost, make an backup of your database
@daniel.dietze how did you change the charger of the database?
I’m facing the problem of ? being saved as $ via api into a json field
If you are using MySQL, here is an article.
https://mathiasbynens.be/notes/mysql-utf8mb4
You can google / ask GPT for more details