Re: AES_ENCRYPT / AES_DECRYPT key_str length question

[Kot Demon]

mysql> select AES_ENCRYPT ('secret', 'password');
+------------------------------------+
| AES_ENCRYPT ('secret', 'password') |
+------------------------------------+
| Ç#þL¢>ä0?iêɪ |
+------------------------------------+
1 row in set (0.00 sec)

il est binaire, conserver dans une colonne BLOB.


mysql> select AES_DECRYPT(encrypted_pass, 'password');
+-------------------------------------------------------------+
| AES_DECRYPT(encrypted_pass,'password') |
+-------------------------------------------------------------+
| secret |
+-------------------------------------------------------------+
1 row in set (0.00 sec)

nom de la colonne BLOB a été "encrypted_pass"

grâce à google translate!