Blob binary data is wrong

[expired user #10828]'s profile image [expired user #10828] posted 7 years ago in General Permalink

My table(utf-8) has a BLOB column which named mydata.

SELECT mydata, hex(mydata) FROM mytable;

The result of mydata and hex(mydata) is different.

0x789CAB3F000175003F, 0x789CABAE0500017500F9

Some data was replaced by 3F.

Is this bug? or normal?

I want to see or edit in 'Data' tab directly.

Help me plz.

Thank you.

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