Garbled when Excel open the output csv

Open WainWong opened this issue 4 years ago • 0 comments

I want to output my sql query results to a csv file，So I used this command： \T csv ; \o ./export.csv ; SELECT 1,2,3; Opening this file with a text editor like notepad++ is normal,but when you open it in excel, it messes up the code.I think it's because this csv doesn't have a bom,Is there a way to specify the output of a utf-8 csv with bom?

Dec 31 '21 14:12 WainWong