MySQL Bugs: #103141: Feature request: Set default display format for binary columns

Bug #103141	Feature request: Set default display format for binary columns
Submitted:	29 Mar 2021 12:09	Modified:	29 Mar 2021 12:25
Reporter:	Frederick Zhang	Email Updates:
Status:	Verified	Impact on me:	None
Category:	Shell General / Core Client	Severity:	S4 (Feature request)
Version:	8.0.23	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently in SQL mode, MySQL Shell shows row binary data directly. Unfortunately this seldom looks nice in terminals and sometimes completely scrambles the output.

It'd be great if users can set a default display format, e.g. HEX, OCT, BASE64, for such fields. For instance, `mysqlsh --sql --binary-format base64 mysql://example.com/Database`.

How to repeat:
N/A

Hello Frederick,

Thank you for the feature request!

regards,
Umesh