Why use VARCHAR for names and CHAR for passwords

Question

I dont understand why the following script:

first_name VARCHAR(20),
last_name VARCHAR(40) NOT NULL,
email VARCHAR(60) NOT NULL,
password CHAR(40) NOT NULL,

has names etc as VARCHAR and password as CHAR.. is it because of how it is retrieved, i.e. names come together, like first name comes with surname, whereas passwords are individual.. im not sure..

Also, in MySQL is script the same thing as code in Python?

Answer 1

Varchar is variable length and Char is fixed length.

Since name,last_name,email generally varies in length, its best to use variable length so only as much storage is used as needed; password length generally depends on the restrictions/conditions as imposed by the application and may be fixed when stored(eg stored as md5 hex string or so), so Char data type is used. If content is of fixed size, char has better performance.

For more, please refer to http://dev.mysql.com/doc/refman/5.7/en/char.html

Answer 2

This looks like a sha1 hash. The hash-algorithm was popular in earlier years by developers. sha1 encrypted passwords always have the fixed length of 40 characters, sha1 is considered as unsafe nowadays and in latter versions of PHP password_verify and password_hash functions has been implemented, which use internally blowfish or bcrypt (60 characters). If the password length is always fixed, like with sha1 CHAR can be used for better performance.