Skip to main content

 

ThoughtSpot

Characters not displaying correctly

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

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:

Figure: Incorrectly displaying characters

bad_chars.png
Instead of displaying correctly like this:

Figure: Correctly displaying characters

good_chars.png

To encode your data as UTF-8:

  1. On Windows, open your CSV file in Notepad. Save the file as CSV with the Unicode option.
  2. On Linux or MacOS, issue a command like:
    $ iconv -f UTF-8 in.csv > out.csv
  3. Drop the table and then recreate it.
  4. Attempt to import it again.
  • Was this article helpful?