Bug #54479 Export Query Results fails in some directories
Submitted: 14 Jun 2010 8:52 Modified: 17 Jun 2010 16:22
Reporter: Anders Stalheim Øfsdahl Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.22 OS:Windows (Windows 7)
Assigned to: Alfredo Kojima CPU Architecture:Any

[14 Jun 2010 8:52] Anders Stalheim Øfsdahl 
Description:
While trying to export the results of a query to a CSV file, it failed with the following error:
"Failed to open output file: `P:\Client\Project\2009\Technical (ASØ)\altitudes_last10_19933.csv`"

If I try to export the exact same query to the parent folder it works as expected.

By testing various folder names it looks like it's the national character Ø that's causing problems.

How to repeat:
Make a folder on C:\ called 'Ø', perform a query on a table and try to export the query results to the C:\Ø folder.

Suggested fix:
Allow characters in the file path.
[14 Jun 2010 13:55] MySQL Verification Team 
Thank you for the bug report.
[15 Jun 2010 2:32] Alfredo Kojima 
fixed
[16 Jun 2010 21:42] Johannes Taxacher 
fix confirmed in repository
[17 Jun 2010 16:22] Tony Bedford 
An entry has been added to the 5.2.23 changelog:

In the SQL Editor, exporting a recordset failed if the target path contained an international character.