Bug #50948 Text data being displayed as blob

• Submitted: 5 Feb 2010 16:13
• Modified: 5 Feb 2010 16:22
• Reporter: Diogo Domanski
• Status: Duplicate
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.15
• OS: Any
• CPU Architecture: Any
• Tags: blog

[5 Feb 2010 16:13] Diogo Domanski

Description:
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