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]