Received: from gateway.heart.com.au (unknown [203.12.235.237]) by postgresql.org (Postfix) with ESMTP id AB6924758DA for ; Wed, 10 Apr 2002 21:50:58 -0400 (EDT) Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au [192.168.0.42]) by gateway.heart.com.au (8.11.2/8.11.2) with ESMTP id g3BCGco03050 for ; Thu, 11 Apr 2002 22:16:38 +1000 Received: from heart.com.au ([192.168.0.53]) by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id LAA22364 for ; Thu, 11 Apr 2002 11:50:49 +1000 Message-ID: <3CB4EC28.2EA348B7@heart.com.au> Date: Thu, 11 Apr 2002 11:51:36 +1000 From: Keith Gray X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: SQL Subject: crypt question (search mail list) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200204/124 X-Sequence-Number: 7389 There was a post about a month ago about crypt and md5 fields being compared to text values... (Can I search the archive... google lists... are these the same as what we see here?) Using PostgreSQL MD5 stored 'userpasswd' field with PHP if(data[userpasswd] == md5(trypassword)) is never true, even when I substr the first 16 characters. They appear the same if I print them! Is this something to do with unicode? ...how do I compare a string value with a unicode string? -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au