| Bug #51041 | Copying result text causes double apostrophes | ||
|---|---|---|---|
| Submitted: | 9 Feb 2010 20:17 | Modified: | 21 Apr 2010 14:11 |
| Reporter: | Bob Dankert | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
| Version: | 5.2.15 Rev 5053 | OS: | Windows (win 7 64) |
| Assigned to: | CPU Architecture: | Any | |
[7 Apr 2010 18:10]
Sergei Tkachenko
It's now possible to copy both quoted & unquoted values using context menu.
[13 Apr 2010 1:16]
Johannes Taxacher
additional options to copy values unquoted have been added to the context menu. confirmed in repository
[21 Apr 2010 14:11]
Tony Bedford
An entry has been added to the 5.2.18 changelog: MySQL Workbench now features the ability to copy field data in the SQL Editor results tab in quoted or unquoted mode.
Description: When copying the field content from a single field of the results tab of a query, the field content gets enclosed in single quotes and any quotes within the field are escaped with double-single quotes (' goes to ''). This would not be a problem if you were copying the data to insert it into a database directly, however it is quite annoying when you are copying large chunks of data and need to preserve the formatting. For example, I will execute a "SHOW CREATE VIEW" command so I can copy a view to another server. After I copy the output, I have to paste it and search for all double quotes and replace them with single quotes. I feel like copying the content field should not enclose the result in quotes unless the user specifies that it should. How to repeat: Copy field content from the result tab by clicking 'Copy Field Content' from the context menu of the query result tab. Suggested fix: Do not enclose the copied field content with quotes, and do not escape the field. Copy the value exactly as it is stored and returned from the database.