crypt question (search mail list) - Mailing list pgsql-sql

From Keith Gray
Subject crypt question (search mail list)
Date
Msg-id 3CB4EC28.2EA348B7@heart.com.au
Whole thread Raw
Responses Re: crypt question (search mail list)  (jeff fitzmyers <fitz22@earthlink.net>)
List 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@heart.com.au


pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Functions in Postgres
Next
From: jeff fitzmyers
Date:
Subject: Re: crypt question (search mail list)