I just tried and it appears the functions DO NOT work in version 3.23
>From: "Neil Tompkins" <neildtompkins@stripped>
>To: mysql@stripped
>Subject: FW: Re: MD5()
>Date: Mon, 12 Mar 2007 09:28:27 +0000
>
>I thought the DES_ENCRYPT/DES_DECRYPT functions were released in mysql
>version 4 however they work with my version of mySQL 3.23 ?
>
>Neil
>
>
>
>
>>From: "Neil Tompkins" <neildtompkins@stripped>
>>To: mysql@stripped
>>Subject: FW: Re: MD5()
>>Date: Sat, 10 Mar 2007 18:24:19 +0000
>>
>>Strange the DES_ENCRYPT/DES_DECRYPT functions work with my version of
>>mySQL 3.23
>>
>>
>>
>>>From: "Neil Tompkins" <neildtompkins@stripped>
>>>To: mogens@stripped
>>>CC: mysql@stripped
>>>Subject: Re: MD5()
>>>Date: Sat, 10 Mar 2007 18:20:43 +0000
>>>
>>>DES_ENCRYPT/DES_DECRYPT appears to be what we require.
>>>
>>>Thanks
>>>Neil
>>>
>>>
>>>
>>>
>>>
>>>>From: "Mogens Melander" <mogens@stripped>
>>>>To: "Neil Tompkins" <neildtompkins@stripped>
>>>>CC: mysql@stripped
>>>>Subject: Re: MD5()
>>>>Date: Sat, 10 Mar 2007 12:19:53 +0100 (CET)
>>>>
>>>>Or you might want to take a look at DES_ENCRYPT/DES_DECRYPT
>>>>funktions in the mysql manual.
>>>>
>>>>On Sat, March 10, 2007 11:18, Ian P. Christian wrote:
>>>> > Neil Tompkins wrote:
>>>> >> I'm looking to use MD5() to encrypt credit card numbers. How do
> I
>>>> >> unencrypt this when reading the value ?
>>>> >>
>>>> >
>>>> > you can't.
>>>> > Google for MD5, or better still look at wikipedia, I'm sure they
> will
>>>> > have something
>>>> >
>>>> > --
>>>> > Ian P. Christian ~ http://pookey.co.uk
>>>> >
>>>> > --
>>>> > MySQL General Mailing List
>>>> > For list archives: http://lists.mysql.com/mysql
>>>> > To unsubscribe:
>>>>http://lists.mysql.com/mysql?unsub=1
>>>> >
>>>> >
>>>> > --
>>>> > This message has been scanned for viruses and
>>>> > dangerous content by OpenProtect(http://www.openprotect.com), and
> is
>>>> > believed to be clean.
>>>> >
>>>>
>>>>
>>>>--
>>>>Later
>>>>
>>>>Mogens Melander
>>>>+45 40 85 71 38
>>>>+66 870 133 224
>>>>
>>>>
>>>>
>>>>--
>>>>This message has been scanned for viruses and
>>>>dangerous content by OpenProtect(http://www.openprotect.com), and is
>>>>believed to be clean.
>>>>
>>>>
>>>>--
>>>>MySQL General Mailing List
>>>>For list archives: http://lists.mysql.com/mysql
>>>>To unsubscribe:
>>>>http://lists.mysql.com/mysql?unsub=1
>>>>
>>>
>>>_________________________________________________________________
>>>MSN Hotmail is evolving - check out the new Windows Live Mail.
>>>http://ideas.live.co.uk/
>>>
>>>
>>>--
>>>MySQL General Mailing List
>>>For list archives: http://lists.mysql.com/mysql
>>>To unsubscribe:
>>>http://lists.mysql.com/mysql?unsub=1
>>>
>>
>>_________________________________________________________________
>>MSN Hotmail is evolving - check out the new Windows Live Mail
>>http://ideas.live.co.uk
>>
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:
>>http://lists.mysql.com/mysql?unsub=1
>>
>
>_________________________________________________________________
>MSN Hotmail is evolving - check out the new Windows Live Mail.
>http://ideas.live.co.uk/
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/mysql?unsub=1
>
_________________________________________________________________
MSN Hotmail is evolving - check out the new Windows Live Mail
http://ideas.live.co.uk
| Thread |
|---|
| • FW: Re: MD5() | Neil Tompkins | 12 Mar |
| • RE: FW: Re: MD5() | Neil Tompkins | 12 Mar |