MySQL Bugs: #51561: Cannot insert multiple line text while editting data

Bug #51561	Cannot insert multiple line text while editting data
Submitted:	26 Feb 2010 17:56	Modified:	21 Apr 2010 10:24
Reporter:	Bob Dankert	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.16 Rev 5249	OS:	Any
Assigned to:	Sergei Tkachenko	CPU Architecture:	Any

Description:
When editting table data, you cannot insert or edit text fields which have multiple lines of text (newline characters in the middle of the text).  Pasting a multiple line value into the field results in only the first line of text being retained.  While editting existing fields, the newlines are treated as if they don't exist, so "line 1\nline 2" is shown as "line1line2".

How to repeat:
Edit char/text fields with newlines

Suggested fix:
Enable multi line support in the editor.  This can be done with a larger text box that is used during editting text/char fields, or it could be a popup window that is used to edit the field value.

Thank you for the problem report. Verified just as described also on Mac OS X.

Now it's possible using Text/BLOB editor which is accessible via cell context menu.

text/blob editor has been added.
right-click the cell and select "open value in editor/viewer" (depending on whether resultset is editable or readonly).
this editor features 2 tabs containing a text- and hex-view/editor. (adding data is only possible on text-tab. editing existing data can be done in both views ... always assuming the recordset is editable)

An entry has been added to the 5.2.18 changelog:

In the SQL Editor, in the results editor, it was not possible to edit or copy data containing multiple lines of text. Further, lines containing new lines were displayed as if the new lines did not exist.

MySQL Workbench now includes a blob editor. This can be accessed by right-clicking in the field to edit and selecting Open Value in Editor.