Bug #84391 Print binary data as hex in the mysql client (contribution)
Submitted: 3 Jan 2017 14:21 Modified: 12 May 2017 1:03
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[3 Jan 2017 14:21] OCA Admin
This bug tracks a contribution by Daniël van Eeden (Github user: dveeden) as described in http://github.com/mysql/mysql-server/pull/118

How to repeat:
See description

Suggested fix:
See contribution code attached
[3 Jan 2017 14:21] OCA Admin
Contribution submitted via Github - Print binary data as hex in the mysql client 
(*) Contribution by Daniël van Eeden (Github dveeden, mysql-server/pull/118#issuecomment-269968353): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_99825311.txt (text/plain), 8.99 KiB.

[3 Jan 2017 14:31] Peter Laursen
I don't think that binary data should print as HEX as default. Binary data are stored as such in order to be used as binary data in an application (think of images, small media files, various sorts of binary patterns etc.) and not primarily intended for a terminal

-- Peter
-- nota MySQL/Oracle person
[3 Jan 2017 15:17] MySQL Verification Team

I agree with Peter, but this is  a patch that deals only with mysql command line client. It does not change, at all, data sent to the applications.

Fully verified.
[12 May 2017 1:03] Paul DuBois
Posted by developer:
Noted in 5.5.57, 5.6.37, 5.7.19, 8.0.2 changelogs.

The mysql client now supports a --binary-as-hex option that causes
display of binary data using hexadecimal notation (0xvalue). Thanks
to Daniël van Eeden for the patch.