Bug #98646 Export cvs file in Unicode without BOM
Submitted: 18 Feb 2020 12:31 Modified: 25 Nov 2022 15:03
Reporter: John King Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S7 (Test Cases)
Version:8.0.18 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[18 Feb 2020 12:31] John King 
Description:
Export query result to csv generates a Unicode text file (csv) without a BOM signaling this. 

Include "EF BB BF" as first three bytes in the file for proper recognition.

How to repeat:
Create and run a query
Click Export
Safe file file as CSV
[19 Feb 2020 7:54] MySQL Verification Team 
Hello John King,

Thank you for the bug report.
Could you please share test case(create table and sample data) to reproduce this issue at our end? Thanks.

Regards,
Ashwini Patil
[1 Mar 2020 23:25] John King 
CREATE TABLE `minidwh`.`test` (
  `idtest` INT NOT NULL,
  `test` VARCHAR(45) NULL,
  PRIMARY KEY (`idtest`));

right click  test
select export
create a new test.csv
click next twice

the exported file does not have a BOM
[27 Mar 2020 12:16] MySQL Verification Team 
Hello John King,

Thank you for the bug report.
Verified as described.

Regads,
Ashwini Patil
[25 Nov 2022 15:03] John King 
It's 2022. what is the problem to fix this?