Hi,
When creating a csv file with data taken from a database, the file is often created with UTF-8 encoding, but sometimes it is created with ANSI encoding.
What does it depend on?
The characters present in the file?
Is there a way to force saving always with UTF-8 encoding?
Most of the time you want an CSV, TSV etc you actually want JSONL. Json line by line.
In the rest of cases you want sqlite ;)
You don't believe how many strange issues I had with CSV, they basically all are fixed with jsonl