2 Replies Latest reply on Nov 20, 2013 12:29 PM by Digdug

    MySql AES_Encrypt values and Coldfusion Encrypt/Decrypt

    Digdug

      So, I'm having trouble figuring this out, and I haven't found an answer online.  Hoping someone here has tried something similar.

       

      I'd like to figure out how to use the Coldfusion Encrypt function so that it generates the same binary value as MySql AES_ENCRYPT.  Similarly, how can I use Coldfusion Decrypt to decrypt values generated by AES_ENCRYPT?

       

      I've tried:

       

      Decrypt( QUERYCOLUMN, "AES", "hex")

      Decrypt( toBase64(QUERYCOLUMN), thisKey.getKey(), "AES", "hex")

      Decrypt( toString(toBase64(QUERYCOLUMN)), thisKey.getKey(), "AES", "hex")

       

      Always returns empty string.

       

      Thoughts?