List:General Discussion« Previous MessageNext Message »
From:Juvenn Woo Date:October 21 2011 3:35am
Subject:Stored aes_encrypted data in a text field
View as plain text  
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

Very thanks!

Juvenn Woo ♫

Stored aes_encrypted data in a text fieldJuvenn Woo21 Oct