This post is a part of the daily blog series
Day #3 – Data Load Non-English Characters
If your csv file has Non-English characters (eg: Chinese characters) to data load into Salesforce. Then are 2 settings you need to set for that data to load into Salesforce otherwise the data will be lost.
- Change the CSV file format to CSV UTF-8. Open the csv or excel file, File–> Save as –> choose CSV UTF-8 (Note this is also .csv but just the encoding is different)
- Change Apex Data loader Settings: In Apex Data loader, open Settings–> and check these 2 checkboxes. Read/Write all CSVs with UTF-8 encoding.
Read all other tips of the blog series here – A Tip A Day, daily dosage of learning!