Encoding option for CSV export

[datlechin]

Problem

CSV import offers UTF-8, ISO Latin 1 and Windows-1252, and CSV export offers no encoding at all. A file destined for a tool that expects Windows-1252, or for Excel on Windows, cannot be produced, and the BOM Excel needs to read UTF-8 correctly is not written either.

Proposed solution

• An Encoding option on CSV export, listing what import already lists.
• A Write BOM option, on by default for UTF-16 and off for UTF-8.
• Report which characters could not be encoded rather than writing a replacement character silently.

Alternatives considered

Convert the file with iconv afterwards.

Related database type

N/A / General