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
27609
February 03, 2005 03:44PM
11540
March 29, 2005 07:54AM
9697
June 26, 2005 10:25PM
10543
July 23, 2005 10:39PM
14567
September 08, 2005 06:04AM
24124
September 08, 2005 06:47AM
7894
September 20, 2005 09:00AM
7412
November 21, 2005 11:09PM
7012
November 28, 2005 05:36AM
6821
November 28, 2005 08:21PM
6885
November 29, 2005 05:51PM
6822
February 18, 2006 06:34PM
Re: using mySQL to store credit card info
6402
April 06, 2006 09:41AM
6673
April 07, 2006 01:28PM
7132
April 19, 2006 08:23PM
9395
May 08, 2006 04:33PM
9126
October 04, 2006 09:11AM
6286
February 20, 2008 12:58PM
6465
February 20, 2008 01:24PM
6351
January 06, 2007 07:26PM
5238
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.