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) Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:* OS:Any (*)
Assigned to: CPU Architecture:Any

[23 Jan 2005 14:15] Olaf van der Spek
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.