Hex fields

roger-u's profile image roger-u posted 2 years ago in General Permalink

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

ansgar's profile image ansgar posted 2 years ago Permalink

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

See the second screen here.

roger-u's profile image roger-u posted 2 years ago Permalink

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 ???)

ansgar's profile image ansgar posted 2 years ago Permalink

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:

Description

roger-u's profile image roger-u posted 2 years ago Permalink

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

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