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).
Request: display binary data as hex, suppress binary NULs
Re: Request: display binary data as hex, suppress binary NULs
You can add a suggestion on the UserVoice forum https://devart.uservoice.com/forums/772 ... -for-mysql
Also, you can vote for the following one https://devart.uservoice.com/forums/772 ... ata-viewer
Also, you can vote for the following one https://devart.uservoice.com/forums/772 ... ata-viewer
Re: Request: display binary data as hex, suppress binary NULs
I would like to, but the "user voice" setup claims I have run out of votes. Those don't appear to ever reappear, which seems kinda stupid. Experienced users find that the only way they can support new suggestions is by un-supporting old ones?
Re: Request: display binary data as hex, suppress binary NULs
You could register a new account and vote under it.