sha1 column type

[Marcus]

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.

[Rik]

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

[Andy Hassall]

On Mon, 26 Jun 2006 13:24:01 -0500, Marcus <Ju********@aol.com> wrote:

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.

SHA1 produces a 20-byte hash, for which you could use BLOB, which can also be
represented as a 40-byte hexadecimal string, for which you can use a character
type.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool