Dear all, 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 http://stackoverflow.com/q/7844366/108112 Very thanks! -- Best, -- Juvenn Woo ♫