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:

bad_chars.png

Incorrectly displaying characters

Instead of displaying correctly like this:
good_chars.png

Correctly displaying characters

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?