title: Proper Data Type for PHP MySQL Phone Number?
body: <p>I'm trying to create a table in PHP for a telephone directory database but I keep getting</p>
  <blockquote>
  <p>Error code 1264: Out of range value for column 'number' at row 1</p>
  </blockquote>
  <p>when I try to submit a 10 digit phone number.</p>
  <p>I tried changing it from <code>BIGINT</code> to <code>VARCHAR</code> but it still throws an error.</p>
  <p>How can I fix this?</p>
  <p>Here is my create table code:</p>
  <pre class="lang-php prettyprint-override"><code>$SQLstring = &quot;CREATE TABLE $TableName(countID SMALLINT 
      NOT NULL AUTO_INCREMENT PRIMARY KEY,
      first_name VARCHAR(40), last_name VARCHAR(40), address VARCHAR(100), city VARCHAR(40), state 
      VARCHAR(40), zip INT, number VARCHAR(40))&quot;;
  </code></pre>