I am enjoying a lot this first week with n8n!
Today, I’m facing a problem that I don’t know how to solve. I need to write texts to a MySQL table. These texts can be wrote in different languages, so when the text contains “srange” symbols liek these (’ " %) the MySQL query node gets an error.
For example, this text in Catalan:
M’agrada molt l’article “Som el 99%” és molt interessant!
I tried adding
.replace("'","''") after the reference to the text to replace the single quotation marks
' into two quotation marks
'', because that’s how it should be done on MySQL. But what about the double quotation marks? And what about the % symbol?
Should I transform it to UTF8 o ANSI or something like these? How can I do it on n8n?