Bug #20428 show variables, showing BLOBs
Submitted: 13 Jun 2006 15:10 Modified: 14 Jan 2009 16:20
Reporter: Hans Ginzel Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S4 (Feature request)
Version:1.1.6 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[13 Jun 2006 15:10] Hans Ginzel
Description:
Statement `show variables' returns blobs, that are not shown.

How to repeat:
show variables

Suggested fix:
Have to show variables return blobs? Why not long text?
Generaly, if BLOB matches some regexp, e.g. /^[[:printable:]]{0,255}$/, it should be shown (or unprintable characters could be substitued with frames or another exotic character).
A very good previewer such as lister (http://www.ghisler.com/lister/) should be used or selecting default previewer. Instaed of or in addition to saving BLOB, openning in an application dialog should be used (same as in web brouser save file/open in application).
[14 Jan 2009 16:20] Susanne Ebrecht
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/