Problem with UTF-8 character in MySQL node

Questions
1

Good day,

I am having problems with a custom MySQL query to a Woocommerce database to get all products and some metadata that is in Spanish and is not being shown well.

Special characters are being shown like this:
ñ → ño
á → á
ó → ó
…

Example:
Baraja española económica

n8n version: 1.14.2
Docker on Digital Ocean
Docker 23.0.6 on Ubuntu 22.04

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @illusionandcards, I am very sorry you are having trouble.

I just tried querying a MySQL table with your example characters, but didn’t notice any problems with these characters:

image
image1405×492 42.3 KB

My example column username uses a utf8mb4_0900_ai_ci default collation:

image

So unfortunately I was not able to reproduce your problem. Can you confirm how exactly your database is set up and how you are querying it?