Hi, Jaco, Did you try adding [imariadb-client] binary-as-hex to ~/.my.cnf ? On Apr 07, Jaco Kroon via discuss wrote:
Hi All,
This would be a mis-feature probably, but please bear with me.
Getting binary data dumped to a terminal is not fun.
Is there perhaps a way to set it such that *binary types would be displayed/presented as hex string rather than raw binary? In particular when using CLI tools?
I'm aware of the HEX() function which achieves same, but you need to do that for every column, when inspecting data and just starting off with something like "select * from" ... I suspect having a flag to inform the cli client tools to present such binary columns as hexadecimal strings instead of dumping raw binary data to the terminal would be most helpful.
Sorry, just had a round of screeching in my ears from "bell" characters and was just wondering if there's a way to not only stop that, but present the data in a more sensible manner regardless, ideally some "opt in" mechanism to maintain backwards compatibility.
Kind regards, Jaco
Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org