Bug #50605 Excel does not know that exported query results CSV file has UTF-8 encoding
Submitted: 25 Jan 2010 20:53 Modified: 9 Jan 2015 16:14
Reporter: Mike Hodgson Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.14 OS:Any
Assigned to: CPU Architecture:Any
Tags: csv, export, Tab Delimited, UTF-8

[25 Jan 2010 20:53] Mike Hodgson 
Description:
MySQL Query Browser could export query results as XML 2003 spreadsheet files; however, the SQL Editor can only export query results in CSV (really tab delimited format). If the query results have UTF-8 characters Excel does not display characters are not display correctly.

How to repeat:
Export query results that contain Kanji UTF8 characters as a CSV file. Open the tab-delimited text file in Excel.

Suggested fix:
Add back support for exporting query results in the XML 2003 spreadsheet file format, or the 2007 XLSX spreadsheet file format.
[26 Jan 2010 12:18] Valeriy Kravchuk 
Thank you for the feature request.
[19 Apr 2010 19:56] Alfredo Kojima 
Hi

Can you make Excel export some Kanji data to CSV and attach the csv file here?
Can it correctly import the file it exports itself? Can you specify the encoding of the file to utf8 in case it exports in some other encoding?