Re: using mySQL to store credit card info

[Carlton Dickson]

I would also like to do the same thing, I have credit card numbers in an old database (DBF) which I have migrated to an MySQL version.

With regards to Michael's question I think AES is strong enough...the MySQL reference doc (http://dev.mysql.com/doc/mysql/en/encryption-functions.html) suggests that AES was previously known as RSA and also points out..
"AES_ENCRYPT() and AES_DECRYPT() were added in MySQL 4.0.2, and can be considered the most cryptographically secure encryption functions currently available in MySQL."
and this guy (http://www.aota.net/forums/showthread.php?postid=46371#post46371) suggests that a strong RSA should be suitable for out task of storing credit card numbers.

I need to find a way of storing these numbers in encrypted form so I am trying to perform some test, i.e. use a keystring and some text to create the encrypted version of the key

e.g. SELECT AES_ENCRYPT('000102030405060708090A0B0C0D0E0F','000102030405060708090A0B0C0D0E0F')

should produce "0a940bb5416ef045f1c39458c653ea5a" but I simple get garbage on my screen, can anyone point me in the right direction to get things working or perhaps show me a tutorial that does?