Re: md5 and table field types

[Fagyal, Csongor]

Egor Egorov wrote:

"Andy B" <[EMAIL PROTECTED]> wrote:
 

hi...

what would be the best field type and length for an md5 encrypted password sort of thing??
   

You can store it in the CHAR(32) column (or VARCHAR(32)).

Or for binary MD5 (and not the hex version) a TINYBLOB(16) should also 
be OK. (And it's shorter.)

- Cs.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]