I'm having trouble encrypting and decrypting data. I used the following insert directly in mysql
insert into interditado (usuario_id, nome, data_cadastro) values (1, AES_ENCRYPT('Zé da Silva','MIICeQIBADANBgkqhkiG9w0BAQEFAASC') , sysdate());
I'm having trouble encrypting and decrypting data. I used the following insert directly in mysql
insert into interditado (usuario_id, nome, data_cadastro) values (1, AES_ENCRYPT('Zé da Silva','MIICeQIBADANBgkqhkiG9w0BAQEFAASC') , sysdate());
I have resolved.
Encryption is available from version 4.0.2.
To work with encryption you must change the Charset of the column to latin1 and Collate to latin1_general_ci.