List:General Discussion« Previous MessageNext Message »
From:Wm Mussatto Date:March 12 2007 8:54pm
Subject:Re: ENCODE() and DECODE()
View as plain text  
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/
>
>


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