Advanced Encryption Standard in Mysql
by Mohan[ Edit ] 2012-09-18 14:10:22
Encoding with a 128-bit key length is used.
AES_ENCRYPT() encrypts a string and returns a binary string.
You can use the AES functions to store data in an encrypted form by modifying your queries:
INSERT INTO t VALUES (1,AES_ENCRYPT('text','password'));
mysql>
mysql>
mysql> select AES_ENCRYPT("text","password") ;
+--------------------------------+
| AES_ENCRYPT("text","password") |
+--------------------------------+
| ö½¨Ã·øÃJ/ª¼Tfâ¬D |
+--------------------------------+
1 row in set (0.00 sec)
