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: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