TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard
verified publisher icon TablePlus

Export CSV containing Chinese.

Open hathaaaway opened this issue 1 year ago • 4 comments

Cannot export querying results including Chinese to CSV file. Can we include encoding options in the export module?

hathaaaway avatar Feb 25 '25 03:02 hathaaaway

Hi @hathaaaway, which database are you using?

sonswift avatar Feb 25 '25 03:02 sonswift

Hi @sonswift, I'm using MySQL.

hathaaaway avatar Feb 25 '25 04:02 hathaaaway

Hi @hathaaaway, I didn’t encounter any issues when exporting a table containing Chinese characters. Could you please describe the problem you’re facing in more detail? If possible, would you mind sharing a small sample of the data you’re trying to export? That would help me investigate the issue more effectively.

sonswift avatar Feb 25 '25 04:02 sonswift

Please find the attached sample for your reference. Columns D, E, F, J, and R are Chinese entities. The results look good in TablePlus Data view but the export CSV could not display the Chinese.

Sample.csv Image

hathaaaway avatar Feb 25 '25 04:02 hathaaaway