SQLite Forum

sqlite3.exe export with bom
Login
I suggest a new commandline option for sqlite3.exe to prefix an exportfile with an utf bom. In doing so there is no more guessing for consuming processes which encoding might the file have. 

For example: Creating an .csv export on MS Windows and doubleclick on the file opens an installed Excel app. But it guesses to load an ansi-encoded file if there is no leading bom. I can add this prefix in a script - but it would be neat to get it just out of the box.

Thx for considering

Horst