Bug #50858 Query results retusn "BLOB" datatype for "TEXT" column returns
Submitted: 2 Feb 2010 21:14 Modified: 3 Feb 2010 8:52
Reporter: Daniel Katz Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.15.5053 OS:Windows (7)
Assigned to: CPU Architecture:Any
Tags: datatype, regression, results blob, text

[2 Feb 2010 21:14] Daniel Katz 
Description:
When running a query, the new query browser will "hide" the contents of the field behind "BLOB" tags instead of showing the contents.

In the older query browser this would happen, but rarely.

How to repeat:
select a text field from a table.

Current workaround is to concat(myfield, '') and the BLOBS return to text.

Currently we are using UTF-8 so I don't know if that's an issue.  (Maybe UTF-8 isn't Latin so it's throwing the BLOB for that reason?)

Suggested fix:
Return text where type is text?
[2 Feb 2010 21:35] Daniel Katz 
Wrong category
[3 Feb 2010 4:42] Valeriy Kravchuk 
Thank you for the bug report. Verified just as described.
[3 Feb 2010 8:52] Sergei Tkachenko 
Duplicate of the bug #50692.