List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:March 12 2007 10:05pm
Subject:Re: ENCODE() and DECODE()
View as plain text  
Do you think these functions would be ideal for my requirements in terms of 
encrypting credit card numbers when stored in a database ?




>From: "Wm Mussatto" <mussatto@stripped>
>To: "Neil Tompkins" <neildtompkins@stripped>
>CC: mysql@stripped
>Subject: Re: ENCODE() and DECODE()
>Date: Mon, 12 Mar 2007 13:54:41 -0700 (PDT)
>
>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" <mussatto@stripped>
> >>To: mysql@stripped
> >>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/mysql?unsub=1
> >>
> >
> > _________________________________________________________________
> > Txt a lot? Get Messenger FREE on your mobile.
> > https://livemessenger.mobile.uk.msn.com/
> >
> >
>
>

_________________________________________________________________
Solve the Conspiracy and win fantastic prizes.  
http://www.theconspiracygame.co.uk/

Thread
ENCODE() and DECODE()Neil Tompkins12 Mar
  • Re: ENCODE() and DECODE()William R. Mussatto12 Mar
Re: ENCODE() and DECODE()Wm Mussatto12 Mar
  • Re: ENCODE() and DECODE()Neil Tompkins12 Mar
Re: ENCODE() and DECODE()Neil Tompkins13 Mar
  • Re: ENCODE() and DECODE()Wm Mussatto13 Mar
  • Re: ENCODE() and DECODE()Aaron Cannon13 Mar