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>
>>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
>> > database which are saved encrypted. My version of mysql is 3.23
>> > 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
>> > functions suitable for my requirements ?
>> > Thanks,
>> > Neil
>>use 'Bin' versions of fields since the encoded data may be binary.
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
> Txt a lot? Get Messenger FREE on your mobile.