AnsweredAssumed Answered

Unable to decode special characters

Question asked by angelica.buffa299959 on Oct 4, 2018
Latest reply on Oct 11, 2018 by srinijilla



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.