Superset 4.0.1 - Exported CSV Contains Garbled Chinese Characters and Numbers about superset HOT 4 OPEN

Hey @TommyLeung-gj! I'm here to help you with the issue you're experiencing with Superset 4.0.1. I'm a bot that can assist you with bug fixes, answer your questions, and guide you on becoming a contributor. Let's dive into resolving the problem together!

To resolve the issue of Chinese characters and numbers being garbled when exporting query results to a CSV file in Superset 4.0.1, you need to ensure that the CSV file is encoded in UTF-8. The df_to_escaped_csv function in the superset/utils/csv.py file should be called with the appropriate encoding settings.

Here is the relevant part of the code with the necessary modification:

csv_data = df_to_escaped_csv(df, index=False, encoding='utf-8', **config["CSV_EXPORT"])

Ensure that the encoding='utf-8' parameter is included in the call to df_to_escaped_csv. This will help in correctly encoding Chinese characters and numbers in the exported CSV file ^[1][2].

To continue talking to Dosu, mention @dosu.

from superset.

Related issue linked above ^^^

Might even be considered a duplicate, really, but they seem kind of unique.

from superset.

No ,It still doesn't work after I changed encoding = "utf-8"

from superset.

maybe there is something wrong in the process of async query , the celery or redis resultbackend cache

from superset.