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-standard. First I thought the problem lies in text encoding of the terminal. But using Java and the JConnector 3.1.10 didn't help. Trying on WinXP produced a correct behavior using PASSWORD(), but SHA1() and MD5() failed also.

Any suggestions?

Kind regards
Martin

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to