Request: display binary data as hex, suppress binary NULs
Posted: Tue 21 Jun 2016 04:07
It would be tremendously helpful if I could copy data out of the data editor without the binary columns. It's annoying to list 40+ columns from a big join I'm using to investigate data, but bad things happen when I paste binary columns to Excel. Excel is also not great at dealing with binary data in export files (I'm not even 100% sure that the files exported are valid - does MS officially allow arbitrary binary data in cells?)
Ideally I'd like two options, one to display binary data as hex (and copy that as hex when copying data), and another to simply suppress display (show ellipses, perhaps) like mysqldump should, rather than producing invalid output (much to the chagrin of people who forget to add whatever the --binhex option is).
Ideally I'd like two options, one to display binary data as hex (and copy that as hex when copying data), and another to simply suppress display (show ellipses, perhaps) like mysqldump should, rather than producing invalid output (much to the chagrin of people who forget to add whatever the --binhex option is).