How to transfer the data type from binary(32) to string?

Get Help
1

i find the table named 'query_execution' in the configed mysql database, and the column named 'hash' is stored as binary(32) in this table. how can i transfer it to string type so i can read it in evidence?

2

Hi @yakunhan
The hash is nothing you can read, it's just a computer generated value.
You just need to convert/cast the column to "read" it:

SELECT CONVERT(`hash` USING utf8), CAST(`hash` AS varchar(32)) FROM `query_execution`
3

i tried it but nothing changed. mysql version is 8.0

1
11920×495 99.3 KB

2
21748×1012 122 KB

4

@yakunhan Use HEX(hash) to make it readable.

5

done! you gave me a professional technical support , thanks a lot