Re: using mySQL to store credit card info

[Ethan Fox]

I am having trouble encrypting and decrypting a particular value. I am testing credit cards and using the example 4111111111111111 which is a standard test visa card.

The problem is that I can encrypt and decrypt lots of values, but not this one. To eliminate possible causes of problems, I am just trying this at the console level of MySQL server.

FOR EXAMPE: SELECT AES_ENCRYPT('4111111111111111','6afgCems46e6NC8JmVzFoN9eda471T')

Which yields: ÖÕ`a™Œ¼2¡1her\“_Ú<”¬!Cž8óÇ
°Í>

When I try to decrypt the value it returns a NULL result and reports that it was trying to decrypt: ÖÕ`a™Œ¼2¡1her\“_Ú<”¬!Cž8óÇ


Please not that the last two encrypted characters are missing.

Not sure why the last two characters are missing or why this particular values, encrypted string is causing errors.