I'm running into an issue when reading data from MySQL that contains special characters, specially Spanish accents.
Tables in MySQL are using this encoding: UTF-8 Unicode (utf8mb4).
My process has three steps:
1. Read data from MySQL
2. Map data
3. Send it to Salesforce
When I debug the process, the operation that reads data from MySQL returns this: evaluaciÃ³n. It should be evaluación.
I put a data processing shape between the MySQL connector and the map, to decode the connection data to UTF-8, and it doesn't work.
Any help will be much appreciated.