Working with AES_ENCRYPT and AES_DECRYPT [closed]

Navigation
0

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());
    
asked by anonymous 15.07.2016 / 22:23

1 answer

0

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.

>     
17.07.2016 / 02:41
WebBrowser I can not play my text in the text box entering data in web api