Foros: 公開討議 (Thread #26256)

AES_ENCRYPT in MySQL (2010-05-14 03:47 by mrt181 #50575)

Hi, when i decrypt a AES encrypted field (Type BLOB), i am not able to see the value. It is still shown as binary.

E.G.
id: BINARY(16)
password: BLOB

select hex(id) as id , aes_decrypt(password,'supersecret') as password from db.user;

Resultset
id password
E55184825E9E11DF80E41AC89CB4B362 <<Binary>>