title: Sqlite3 maximum primary key value
body: <p>I have table with INTEGER PRIMARY KEY and I cannot insert value greater then 2147483647 as a key. Is it possible to increase this value somehow?</p>
  
  <p>UPDATE:
  Ok, I have php script:</p>
  
  <pre><code>&lt;?php
  
  $sqlite_db = new SQLite3('test');
  $sqlite_db-&gt;exec('CREATE TABLE test (n UNSIGNED INTEGER)');
  
  $ns = array(1111111111,2222222222,3333333333,4444444444,5555555555,6666666666,7777777777);
  
  foreach ($ns as $n)
  {
      $statement = $sqlite_db-&gt;prepare('INSERT INTO test (n) VALUES (:n)');
      $statement-&gt;bindValue(':n', $n, SQLITE3_INTEGER);
      $statement-&gt;execute();
  }
  
  $sqlite_db-&gt;close();
  ?&gt;
  </code></pre>
  
  <p>and what I get in test database is that:</p>
  
  <pre><code>root@localhost:~# sqlite3 test 
  SQLite version 3.7.3
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite&gt; select * from test;
  1111111111
  -2072745074
  -961633963
  149477148
  1260588259
  -1923267926
  -812156815
  </code></pre>
  
  <p>So my question is: how to insert large values into sqlite database from php?</p>
  
  <p>UPDATE2:</p>
  
  <p>I have changed foreach body to:</p>
  
  <pre><code>$sqlite_db-&gt;exec("INSERT INTO test (n) VALUES ({$n})");
  </code></pre>
  
  <p>and it works ok now.</p>