Posted by J.O. Aho on 11/17/05 17:40

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

[Back to original message]