Archived Forum Post

Index of archived forum posts

Question:

CkCrypt2__mySqlAesEncrypt with unicode chars

Jul 20 '17 at 03:32

Hello Everybody! I use Delphi 10. My MySQL server use UTF-8 codepage, I try execute AES_ENCRYPT function and CkCrypt2mySqlAesEncrypt, but I get various results, because the CkCrypt2mySqlAesEncrypt function uses the ANSI encoding. When decrypting CkCrypt2mySqlAesDecrypt, I get only the question marks. How to implement AES-128-CBC crypt like MySQL AES_ENCRYPT with UTF-8 encoding? I could use CkCrypt2encryptStringENC, but I dont know which IV parameter uses AES_ENCRYPT.