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
27852
February 03, 2005 03:44PM
11653
March 29, 2005 07:54AM
9803
June 26, 2005 10:25PM
10653
July 23, 2005 10:39PM
14731
September 08, 2005 06:04AM
24262
September 08, 2005 06:47AM
8012
September 20, 2005 09:00AM
7528
November 21, 2005 11:09PM
7089
November 28, 2005 05:36AM
6920
November 28, 2005 08:21PM
6981
November 29, 2005 05:51PM
6916
February 18, 2006 06:34PM
Re: using mySQL to store credit card info
6502
April 06, 2006 09:41AM
6780
April 07, 2006 01:28PM
7219
April 19, 2006 08:23PM
9507
May 08, 2006 04:33PM
9235
October 04, 2006 09:11AM
6387
February 20, 2008 12:58PM
6566
February 20, 2008 01:24PM
6461
January 06, 2007 07:26PM
5344
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.