From: Neil Tompkins Date: March 12 2007 3:02pm Subject: RE: FW: Re: MD5() List-Archive: http://lists.mysql.com/mysql/205525 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; format=flowed I just tried and it appears the functions DO NOT work in version 3.23 >From: "Neil Tompkins" >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" >>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" >>>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" >>>>To: "Neil Tompkins" >>>>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=mogens@stripped >>>> > >>>> > >>>> > -- >>>> > 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=neildtompkins@stripped >>>> >>> >>>_________________________________________________________________ >>>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=neildtompkins@stripped >>> >> >>_________________________________________________________________ >>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=neildtompkins@stripped >> > >_________________________________________________________________ >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=neildtompkins@stripped > _________________________________________________________________ MSN Hotmail is evolving - check out the new Windows Live Mail http://ideas.live.co.uk