Posted by Rik on 06/26/06 18:50

Marcus wrote:
> Hello,
>
> I have read several online tutorials advocating storing a sha1()
> hashed password in a column of type BLOB. As far as I can tell,
> sha1() always returns a string of 40 characters, regardless of the
> size of the original input. Is there any reason I can't store this
> as type CHAR? I am running MySQL 4.1.x. Thanks in advance.

NATIONAL] CHAR(M) [BINARY | ASCII | UNICODE]
A fixed-length string that is always right-padded with spaces to the
specified length when stored. M represents the column length. The range of M
is 0 to 255 characters.

Should be possible without any problems...

Grtz,
--
Rik Wasmus

[Back to original message]