Bug #50948 Text data being displayed as blob
Submitted: 5 Feb 2010 16:13 Modified: 5 Feb 2010 16:22
Reporter: Diogo Domanski Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.15 OS:Any
Assigned to: CPU Architecture:Any
Tags: blog

[5 Feb 2010 16:13] Diogo Domanski
Whenever a result set contains a TEXT column data, it is displayed as 'blob' and its content cannot be accessed.

I even tried to right click on the cell and select "Copy field content", but nothing is copied to transfer area.

How to repeat:
-- Create a simple table with a text column
CREATE TABLE mytable (
   mytext text not null
) type InnoDB;

-- Insert some example data
INSERT INTO mytable SET mytext = 'Here is the first row';
INSERT INTO mytable SET mytext = 'Here is the second row';
INSERT INTO mytable SET mytext = 'Here is the third row';

-- At the SQL Editor, select the table content
SELECT * FROM mytable;

The result set appears but every row is displayed as 'blob' and the data cannot be accessed
[5 Feb 2010 16:22] Johannes Taxacher
This is a duplicate of Bug #50692