Explains what the feature is or what its benefits are to the user or customer.
Your CSV files are more likely to load smoothly if they are encoded with UTF-8. If you're having problems with some characters rendering incorrectly, you can convert the files to UTF-8 encoding before loading the data.
You might see unexpected characters in your data, especially characters whose ASCII values are at the high and low end of possible values. Some examples of characters that can appear incorrectly are: æ, ñ, ä, í, ö.
If this happens, your data will look like this:
- On Windows, open your CSV file in Notepad. Save the file as CSV with the Unicode option.
- On Linux or MacOS, issue a command like:
$ iconv -f UTF-8 in.csv > out.csv
- Drop the table and then recreate it.
- Attempt to import it again.