View VARBINARY as text

Ghet's profile image Ghet posted 2 months ago in General Permalink

Hello! Wondering why my VARBINARY values are displayed like this when I turn on "View binary data as text"?

image.png

It looks normal in HEX format:

image.png

Ghet's profile image Ghet posted 2 months ago Permalink

Just to add that I am on lastest version, 12.8.0.6910.

ansgar's profile image ansgar posted 2 months ago Permalink

That's expected. Your binary fields contain mostly 00/NUL/Null characters. Hex 07 is a BEL/Bell character. Both are just control characters, and have no visual representation. What do you expect here to be displayed?

grafik.png

Please use the option "View binary data as text" only for fields of which you know they contain normal text with printable characters.

Ghet's profile image Ghet posted 2 months ago Permalink

Thank you for your reply!

I have missunderstood "View binary data as text" feature. My data is just an array of bytes where each byte is real number, not a text. So for example 0x07 is representing a number 7 as first element of that array.

ansgar's profile image ansgar posted 2 months ago Permalink

Oh ok, understand. I'm afraid HeidiSQL will only show unreadable stuff in that case.

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