|
|
Posted by Andy Hassall on 06/26/06 19:51
On Mon, 26 Jun 2006 13:24:01 -0500, Marcus <JumpMan222@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 :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Navigation:
[Reply to this message]
|