Request: display binary data as hex, suppress binary NULs

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
digiflex
Posts: 11
Joined: Tue 16 Jun 2015 02:16

Request: display binary data as hex, suppress binary NULs

Post by digiflex » 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).

alexa

Re: Request: display binary data as hex, suppress binary NULs

Post by alexa » Tue 21 Jun 2016 10:12

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

digiflex
Posts: 11
Joined: Tue 16 Jun 2015 02:16

Re: Request: display binary data as hex, suppress binary NULs

Post by digiflex » Wed 22 Jun 2016 06:52

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?

alexa

Re: Request: display binary data as hex, suppress binary NULs

Post by alexa » Wed 22 Jun 2016 10:52

You could register a new account and vote under it.

Post Reply