Home > Net >  The.net and MYSQL AES_DECRYPT decryption result is NULL
The.net and MYSQL AES_DECRYPT decryption result is NULL

Time:05-01



 


The SELECT F_CustomerId, CAST (AES_DECRYPT (unhex (F_MobileEncryption), '* * * * * * * * * *') AS CHAR (50)) AS F_MobileDecrypt
, CAST (AES_DECRYPT (unhex (F_Mobile2Encryption), '* * * * * * * * * *') AS CHAR) AS F_Mobile2Decrypt
, CAST (AES_DECRYPT (unhex (F_Mobile3Encryption), '* * * * * * * * * *') AS CHAR) AS F_Mobile3Decrypt FROM lfine_crm_customer



The same statement, the database can see decryption result, but you can't see the code in decryption result,

Pray god grant instruction
  • Related