On Mon, March 12, 2007 8:04, Neil Tompkins said: > I've been researching the best method to store credit card numbers in a > database which are saved encrypted. My version of mysql is 3.23 therefore > I > think the only function I could use is > > ENCODE() and DECODE(). > > I've tried these functions and they appear to work as I want. I've a > couple > of questions though, can I use varchar when saving the data and are these > functions suitable for my requirements ? > > Thanks, > Neil use 'Bin' versions of fields since the encoded data may be binary.
Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]