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
dnelson@stripped
