From: Dan Nelson
Date: November 13 2003 10:05pm
Subject: Re: Problems storing SHA1 Hash
List-Archive: http://lists.mysql.com/mysql/153810
Message-Id: <20031113220512.GF24018@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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 a=
pplication...
> This is the original SELECT Command:
> INSERT INTO Auth$ VALUES ('System', '
> % 3/4 =C3=BFX;Z^E(xB9=C2=AA?=16(?U?N~oSSE?$03=C3=87^O?#^1=7Fj=16?'U'Y=C3=
=B9=C3=BF??-#N^A?=C2=B7"`U=C3=BC=03=C2=BD=C3=AE[.=1F6?thth^=12?', 3)
> but the stored values are:
> % 3/4 =C3=BFX;Z^E(xB9=C2=AA?=16(?U?N~oSSE?$03=C3=87^O?#^1=7Fj=16?'U'Y=C3=
=B9=C3=BF??-#N^A?=C2=B7"`U=C3=BC=03=C2=BD=C3=AE[.=1F6?thth^=12?
> 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.

--=20
	Dan Nelson
	dnelson@stripped