crypt question (search mail list)

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: SQL <pgsql-sql(at)postgresql(dot)org>
Subject: crypt question (search mail list)
Date: 2002-04-11 01:51:36
Message-ID: 3CB4EC28.2EA348B7@heart.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)heart(dot)com(dot)au

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jeff fitzmyers 2002-04-11 02:04:43 Re: crypt question (search mail list)
Previous Message Peter Eisentraut 2002-04-11 00:55:56 Re: Functions in Postgres