We have thousands of aes_encrypted data accidentally stored in a text field,
from which we're struggling to recover the data back. Simply convert the
text field to a blob field does not help. Various tricks have been tried,
but with no luck. Now I'm worried that when a blob stored into a text, the
bits are not preserved. In that case, I don't think we can get it back.
I have this question asked on stackoverflow as well, hope you can help!
MySQL: how to extract encrypted blob from a text field
Juvenn Woo ♫
|• Stored aes_encrypted data in a text field||Juvenn Woo||21 Oct|