From: Dan Nelson (dnelsonallantgroup.com)
Date: Thu Nov 13 2003 - 16:05:12 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
        dnelsonallantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]