PASSWORD function in MySQL

PASSWORD function in MySQL

am 17.11.2005 16:29:37 von thehuby

How big should a password field be in a table when using the MySQL
PASSWORD function?

Can I calculate how big the hashed value will be (in terms of number of
characters) if I limit the user to say 16 character passwords?

Thanks,

Rick
www.e-connected.com

Re: PASSWORD function in MySQL

am 17.11.2005 16:35:48 von Shion

thehuby wrote:
> How big should a password field be in a table when using the MySQL
> PASSWORD function?
>
> Can I calculate how big the hashed value will be (in terms of number of
> characters) if I limit the user to say 16 character passwords?

It will 16 characters.


//Aho

Re: PASSWORD function in MySQL

am 17.11.2005 16:40:03 von Shion

thehuby wrote:
> How big should a password field be in a table when using the MySQL
> PASSWORD function?
>
> Can I calculate how big the hashed value will be (in terms of number of
> characters) if I limit the user to say 16 character passwords?

Mysql < 4.1 --> 16 bytes
Mysql >=4.1 --> 41 bytes

If you want to limit the size of the typed password, you need to do that in
the php code, but even if it's just one character long the has value will be
16 (or 41) bytes long.


//Aho