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
27741
February 03, 2005 03:44PM
11609
March 29, 2005 07:54AM
9746
June 26, 2005 10:25PM
10602
July 23, 2005 10:39PM
14651
September 08, 2005 06:04AM
24208
September 08, 2005 06:47AM
7950
September 20, 2005 09:00AM
7465
November 21, 2005 11:09PM
7055
November 28, 2005 05:36AM
6875
November 28, 2005 08:21PM
6938
November 29, 2005 05:51PM
6869
February 18, 2006 06:34PM
Re: using mySQL to store credit card info
6449
April 06, 2006 09:41AM
6726
April 07, 2006 01:28PM
7171
April 19, 2006 08:23PM
9464
May 08, 2006 04:33PM
9188
October 04, 2006 09:11AM
6349
February 20, 2008 12:58PM
6524
February 20, 2008 01:24PM
6423
January 06, 2007 07:26PM
5286
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.