Re: aes_encrypt() key_str: What are good values to use?

[Ashley Sewell]

I think you'll find that 128 bit encryption doesn't mean the maximum key size is 128 bits (16 bytes) as well.

You can verify this with the following statement:

select if(aes_encrypt('plain text','1234567890123456')=aes_encrypt('plain text','12345678901234567'),'16 char max','17 works fine') AS output

+---------------+
| output |
+---------------+
| 17 works fine |
+---------------+
1 row in set (0.00 sec)

Ashley