Display the content of binary fields (if possible)

mw_jko posted 3 months ago in Feature discussion

Hi there,

I love working with HeidiSQL but I'm missing a feature but I'm not sure if it's too borderline: display binary columns as text if possible.

Some background: I'm working with a software where lots of columns are of type VARBINARY, TINYBLOB or similar. Most of the time plaintext is stored in there (it seems the decision to make this fields BINARY was for performance/storage reasons and was not in my hand).

HeidiSQL shows the content of BINARY columns as hex no matter what. SQLYog shows the content of BINARY columns "readable" if the content "translates" into ascii (maybe even iso8859/utf-8, did not check) and as binary if "real" binary data is stored.

Is it possible to implement this in HeidiSQL as well?

ansgar posted 3 months ago

Just press the button "View binary data as text", and you're done :)

1 attachment(s):
  • binary-astext
mw_jko posted 2 months ago

Just press the button "View binary data as text", and you're done :)

Omg why did I never notice this little icon! Thank you so much!

ansgar posted 2 months ago

You were by far not the first one missing that icon. That's why I recently changed the default state of this button on a fresh HeidiSQL install to activated.

Please login to leave a reply, or register at first.