Re: password(), sha1() and md5()

On 18/08/2005, Martin Schwarz wrote: > When using > 'update TABLE set FIELD=PASSWORD('foo');' > the query > 'select * from TABLE where FIELD=PASSWORD('foo');' > delivers an empty set. > > Same with the SHA1 or MD5 functions. What is the data type of your FIELD column? -- felix -- MySQL Gener

password(), sha1() and md5()

Hello! I am facing the following problem: When using 'update TABLE set FIELD=PASSWORD('foo');' the query 'select * from TABLE where FIELD=PASSWORD('foo');' delivers an empty set. Same with the SHA1 or MD5 functions. I am using Mac OS X Tiger (same problem with Panther) and MySQL 4.1.12-standar