dowzer - 4:53 am on Mar 9, 2011 (gmt 0)

Thanks for replying - I did get this sorted so thought I should share in case it helps someone else!

The problem is the field type - AES_ENCRYPT will not work with VARCHAR, the field type needs to be set to BLOB. Once I changed all the fields to BLOB it now encrypts and decrypts great :)