On 10/31/25 13:43, info wrote:
> This is an MD5 hash value from a MySQL table, as shown by MySQL Workbench:
>
>
> I see 16 bytes encoded in hexadecimal, and I can validate that this is
> true, for example, in PHP.
> And this is the same record/column, in Squirrel SQL:
>
>
>
> I see a different number of different bytes.
> Should not both Squirrel SQL and MySQL Workbench show the same
> information? What does Squirrel SQL show?
>
Sorry, I can't reproduce your problem. Below you find the script I tried
to reproduce it with. In my test, when using "Number base"=HEX, SQuirreL
displayed the BLOB data the same way as in the script.
Gerd
-------Script----------------------------
create table BLOB_TEST
(
BlobTestId Integer NOT NULL PRIMARY KEY,
BlobTestCol BLOB NULL
)
INSERT INTO BLOB_TEST (BlobTestId, BlobTestCol)
VALUES(2, UNHEX('af3e485717850f1c1a9527a4018991cc'))
SELECT * FROM BLOB_TEST
|