Bug #6916 Blob Text does not show up in Field Viewer's Text Pane
Submitted: 1 Dec 2004 14:59 Modified: 1 Dec 2004 17:11
Reporter: St P Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.2 OS:Windows (WinXP Professional)
Assigned to: Michael G. Zinner CPU Architecture:Any

[1 Dec 2004 14:59] St P
Description:
In MySQL Query Browser v1.1.2, if you create a Blob column and enter some data in it, you cannot view it afterwards with the Field Viewer. In fact, the text is visible only in the Binary pane, but not in the Text Pane. This means that you cannot edit it.

How to repeat:
No suggestions.

Suggested fix:
No suggested fixes.
[1 Dec 2004 17:11] Michael G. Zinner
Thanks for reporting. We are now hiding the Text Tab Sheet when you view a Blob field. It is not possible at this time to edit text that is stored inside a BLOB field. You just may load or store to a file.

If you have to store large amout of text you should use a TEXT (MEDIUMTEXT, LARGETEXT) datatype instead. With TEXT columns you get a correct characterset / collation and you can edit this text just like normal VARCHAR columns.

As a workaround - e.g. if you have to store Word documents inside the database - we will offer the ability to launch external editors for different datatypes in one of the next versions.