Re: using mySQL to store credit card info

[Ankit Patel]

Ankit Patel wrote:
> Hello Everybody,
> I have a question regarding,
> AES_ENCRYPT/AES_DECRYPT. according to
> documentation of mysql on encryption function
> there is following Note in begining.
> Note: All encryption functions return binary
> strings. Use a BLOB column rather than a CHAR or
> VARCHAR column to avoid potential problems with
> trailing space removal that would change data
> values.
>
> Since I havent seen this issue in this forum. I am
> wondering I have a varchar column type rightnow,
> and i want to use AES_ENCRYPT/AES_DECRYPT
> function, do I must have to change datatype to
> BLOB?? what are your experiences?? I have a very
> big production DB and its in use 24/7.
>
> what are your openions??
>
> regards,
> Ankit Patel