aes_decrypt no longer working

Hi,

I got an upgrade yesterday and after that the aes_decrypt no longer shows the decrypted value. It shows something other than the encrypted value but it is not the correct decrypted value.

When I go to the terminal and run the exact same sql query on the server the decrypted value appears correctly.

I have tried it on two different servers (difft databases) and the problem is the same on HeidiSQL.

Cyril

Perhaps you should show the BLOBs as text? See the data help page.

Here is the output using the aes_decrypt sql query in HeidiSQL: 0x31303137353433313537 since the upgrade.
This is the output using the terminal on the server: 1017543157.
The raw data without using aes_decrypt in HeidiSQL looks like: 0x627A8EC29CBE4A5A5A5324DD1BF6CC21

Yes, the "0x" tells you that this is displayed in hexadecimal format. That's what I meant with my previous post. Just press the button "Show BLOBs as text instead of hex".

It worked. Thank you!