Quote:
Originally Posted by BigBen
See how the insert is done and what kind of encoding is being used.
|
Yup, this would be how to solve it.
Just find what's done to the text before it's inserted, then reverse that when it comes out. A BLOB field itself doesn't do its own encrypting or anything.
On the small chance there is nothing being done to the data before it's put into the database, check for any Triggers in MySQL as there could be one that ON INSERT or ON UPDATE encrypts the value in that field.