Hi!
Describe the issue/error/question
When I have a workflow posting rows to NocoDB, having unicode characters in the strings causes NocoDB to reject with error 400, with an error Incorrect String Value from MariaDB. I initially thought this was a NocoDB issue, but I’m not sure anymore, because using curl I can insert unicode characters without problem in NocoDB. For example:
curl -X 'POST' \
'http://pi4:4567/nc/random_2fmg/api/v1/table2' \
-H 'accept: application/json' \
-H 'xc-auth: replaced \
-H 'Content-Type: application/json' \
-d '{
"title": "string⏪",
}'
works flawlessly.
What is the error message (if any)?
400 Bad request - check your parameters
the trace shows the original error as Incorrect string value: '\xF0\x9F\x8E\xAA \xE2...' for column
d1.
nc_2fmg__testemails.
subject at row 1"
Please share the workflow
Share the output returned by the last node
ERROR: UNKNOWN ERROR - check the detailed error for more information
Bad request - please check your parameters
Information on your n8n setup
- n8n version: latest docker container for arm7
- Database you’re using (default: SQLite): mariadb (linuxserver.io latest for arm7)
- Running n8n with the execution process [own(default), main]: ?
- Running n8n via [Docker, npm, n8n.cloud, desktop app]: Docker on Rapsberry Pi4 32 bit