"500 Internal Server Error When Inserting Certain Chinese Characters (e.g., 𦈡) in Strapi"

Hello Strapi Community,

I am encountering an issue with my Strapi application when trying to store certain Chinese characters, specifically the character 𦈡, in my database. Whenever I attempt to insert this character, the API returns a “500 Internal Server Error”. This error seems to occur only with certain complex characters.

Here are some details about my setup:

Strapi Version: 4.23.1
Database Type: MySQL
Database Version: 8.0.18
Node.js Version:v18.20.2
Operating System: macos 10.14
I have checked that my database is configured to use UTF-8 encoding, and other Chinese characters are being stored without any issues. Here’s what I’ve tried so far:

Ensuring the database, table, and column character sets are set to utf8mb4.
Checking error logs, but the logs do not provide a clear indication of what might be causing the issue.
Trying to insert simpler Chinese characters, which works without any issues.
Could this be a limitation with Strapi or the underlying database in handling certain Unicode characters? Has anyone else faced a similar issue, and how did you resolve it?

Any help or guidance would be greatly appreciated!

Thank you!

This topic has been created from a Discord post (1234082645672202290) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord