| Author |
PASSWORD function in MySQL
|
|
| thehuby 2005-11-17, 6:57 pm |
| 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
| |
| J.O. Aho 2005-11-17, 6:57 pm |
| 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
| |
| J.O. Aho 2005-11-17, 6:57 pm |
| 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
|
|
|
|