Re: using mySQL to store credit card info
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
Subject
Views
Written By
Posted
27770
February 03, 2005 03:44PM
11617
March 29, 2005 07:54AM
9753
June 26, 2005 10:25PM
10614
July 23, 2005 10:39PM
14669
September 08, 2005 06:04AM
24215
September 08, 2005 06:47AM
7960
September 20, 2005 09:00AM
7471
November 21, 2005 11:09PM
7062
November 28, 2005 05:36AM
6884
November 28, 2005 08:21PM
6944
November 29, 2005 05:51PM
6883
February 18, 2006 06:34PM
Re: using mySQL to store credit card info
6457
April 06, 2006 09:41AM
6745
April 07, 2006 01:28PM
7179
April 19, 2006 08:23PM
9472
May 08, 2006 04:33PM
9198
October 04, 2006 09:11AM
6358
February 20, 2008 12:58PM
6533
February 20, 2008 01:24PM
6431
January 06, 2007 07:26PM
5296
February 16, 2009 07:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.