Hex fields

I would really like to be able to show a column in Hex - maybe only Integer type fields...

HeidiSQL shows hex contents for binary columns. Isn't that what you mean?

See the second screen here.

not really ... i would like to be able to see Integer columns in Hex

(I have a binary field... it shows as normal number plus a ling string of dots ???)

You could define your Integer columns as binary instead, that would tell HeidiSQL to display hex instead. But that would be crazy.

However, be sure the binary-as-text button is not pressed:

No! that didn't work. I had an INT value 12345 i changed that field to Binary length 8 and it now shows 0x3132333435000000 12345 is 0x3039 ditto 1025 shows as 0x3130323500000000 instead of 0x401

And when i tried to vchange the field back to INT it said the value was too big!

Also i tried to edit the value ... and heidisql crashed (twice) when i went to save it. I tried to send the error report, clicked to edit the screenshot and it closed! I will try again (but i am still using V11.1) so maybe i'll update first