Export csv - Use UTF-8 format with BOM to be compatible with Microsoft Excel

[FALLAI-Denis]

Description of the feature or enhancement

The IBM Db2 for z/OS Developper extension allows you to save the result of an SQL query in a .csv file.
The purpose of saving such a file is to be able to rework it in a spreadsheet, and a priori most often in Microsoft Excel.
This file is saved in simple UTF-8 format, and Excel does not read it correctly, (visible when using languages ​​other than English, as in my case French).

To be compatible with Microsoft Excel, you must save the file in UTF-8 with BOM (Byte Order Mark).

See: Opening CSV UTF-8 files correctly in Excel

However, the Git documentation advises against using the UTF-8-BOM format... but does not say that it does not work.

Thanks.

[ThomasLieser]

A work-around would be to use a tool like NotePad++ which lets you convert to a file with a UFT-8 BOM

[FALLAI-Denis]

Hi,

VS Code himself can rewrite file with UTF-8-BOM, (or Windows-1252 for us), but this need an action before opening file with Excel.