We are using AES_ENCRYPT to encrypt some information in a mySQL database. It works 99.9% of the time, but there are times when it encrypts it in such a way that it cannot be decrypted.
The encrypted information is stored in a BLOB field. All non-numeric characters are stripped out before it is encrypted. I have tried to duplicate the issue a million times, but cannot seem to make it happen. Has anyone experienced this issue with AES_ENCRYPT? Is there something I should be looking for or ways that I can try to break it?
