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/