In the last episode (Nov 13), Paride De Gasperis said:
> Hello all,
> I have a problem storing an SHA1 hash generated as user password for an
> application...
> This is the original SELECT Command:
> INSERT INTO Auth$ VALUES ('System', '
> % 3/4
> ÃX;Z^E(xB9Â?(?U?N~oSSE?$03Ã^O?#^1j?'U'YÃÃ??-#N^A?Â"`UÃÂÃ[. 6?thth^?',
> 3)
> but the stored values are:
> % 3/4
> ÃX;Z^E(xB9Â?(?U?N~oSSE?$03Ã^O?#^1j?'U'YÃÃ??-#N^A?Â"`UÃÂÃ[. 6?thth^?
> this differes from the original in some characters and the password check fails...
Those two strings are identical; I moved the first one onto its own
line so they line up. Make sure the field is not a VARCHAR field (use
a BLOB) and you should be okay.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
