title: Why use VARCHAR for names and CHAR for passwords
body: <p>I dont understand why the following script:</p>
  
  <pre><code>first_name VARCHAR(20),
  last_name VARCHAR(40) NOT NULL,
  email VARCHAR(60) NOT NULL,
  password CHAR(40) NOT NULL,
  </code></pre>
  
  <p>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..</p>
  
  <p>Also, in MySQL is script the same thing as code in Python?</p>