Bug #8095 MySQL client: show blob as hex

• Submitted: 23 Jan 2005 14:15
• Modified: 24 Jan 2005 16:01
• Reporter: Olaf van der Spek (Basic Quality Contributor)
• Status: Not a Bug
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: *
• OS: Any (*)
• CPU Architecture: Any

[23 Jan 2005 14:15] Olaf van der Spek

Description:
Would it be possible to add a 'show blob as hex' option to the client such that blob fields to not cause the terminal to go weird on select * queries?

How to repeat:
-

[23 Jan 2005 15:03] MySQL Verification Team

There are already functions in the server that can emulate the behaviour, plus there 
are GUI clients that can represent BLOB columns in different manners.

[23 Jan 2005 15:51] Olaf van der Spek

This was about *the* mysql command line client, not an arbitrary client.
Yes, you could use select hex(field), field1, field2, etc, but that's a lot more work then typing select * when debuging/testing via the command line.

[24 Jan 2005 16:01] Sergei Golubchik

I agree, it may be a useful feature. May be not only as command line
switch, but as \x command too.

I could've say "we will add it to our todo", but  the truth it that given the size of this "todo", the feature will hardly be done anytime soon :(

On the other hand, it's pretty straightforward feature that could be imlpemented relatively easy. So, if you have the courage to add it yourself, it can appear in the much earleir release.