How to work with AES_ENCRYPT and AES_DECRYPT

Asked

Viewed 325 times

0

I’m having trouble encrypting and decrypting data. I used the following direct input in mysql

insert into interditado (usuario_id, nome, data_cadastro) values (1, AES_ENCRYPT('Zé da Silva','MIICeQIBADANBgkqhkiG9w0BAQEFAASC') , sysdate());
mysql

1 answer

0


I resolved. Encryption is available from version 4.0.2.
To work with cryptography one must change the Charset from column to latim1 and Leotard for latin1_general_ci.

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.