Bug #51214 Can't edit Text Blob Data in Mysql Workbench
Submitted: 16 Feb 2010 17:33 Modified: 18 Feb 2010 12:17
Reporter: Dan McDonald Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.2.14 OS:Any
Assigned to: CPU Architecture:Any

[16 Feb 2010 17:33] Dan McDonald
Description:
Text Blobs were readable and editable using mysql-query-browser.  Mysql Workbench does not have any facilities for dealing with blob data

How to repeat:
create a schema with a TEXT type:
CREATE TABLE `snmp` (
  `host` varchar(64) NOT NULL default '',
  `authpasswd` tinytext NOT NULL,
  `privpasswd` tinytext NOT NULL,
  `engineid` tinytext,
  PRIMARY KEY  (`host`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

add some data
Attempt to edit using Mysql Workbench
Observe that instead of the text values for authpasswd, privpasswd, or engineid, only two periods are shown.  Note that there are no right-click menu options or command ribbon options to edit the blob values.

Suggested fix:
Provide the same level of support for text blobs and binary blobs in Mysql workbench as mysql-query-browser had.
[18 Feb 2010 12:17] Johannes Taxacher
This is a duplicate of Bug #50692