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
27957
February 03, 2005 03:44PM
11679
March 29, 2005 07:54AM
9822
June 26, 2005 10:25PM
10679
July 23, 2005 10:39PM
14766
September 08, 2005 06:04AM
24312
September 08, 2005 06:47AM
8077
September 20, 2005 09:00AM
7555
November 21, 2005 11:09PM
7115
November 28, 2005 05:36AM
6948
November 28, 2005 08:21PM
7006
November 29, 2005 05:51PM
6946
February 18, 2006 06:34PM
Re: using mySQL to store credit card info
6521
April 06, 2006 09:41AM
6812
April 07, 2006 01:28PM
7244
April 19, 2006 08:23PM
9527
May 08, 2006 04:33PM
9261
October 04, 2006 09:11AM
6406
February 20, 2008 12:58PM
6604
February 20, 2008 01:24PM
6491
January 06, 2007 07:26PM
5360
February 16, 2009 07:37PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.