On Mon, March 12, 2007 13:04, Neil Tompkins said: > Sorry Bill, I'm unsure what you mean by bin My error, too early in the morning here 'blob' > >>From: "William R. Mussatto" <[EMAIL PROTECTED]> >>To: mysql@lists.mysql.com >>Subject: Re: ENCODE() and DECODE() >>Date: Mon, 12 Mar 2007 10:31:53 -0700 (PDT) >> >>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] >> > > _________________________________________________________________ > Txt a lot? Get Messenger FREE on your mobile. > https://livemessenger.mobile.uk.msn.com/ > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]