title: SQL (SQLite) Madness with names
body: <p>I spent 2 days trying to work out a really annoying simple problem: I'm creating a database in c++: </p>
  
  <pre><code>sqlite3 *database;
  rc = sqlite3_open(dbname, &amp;database);
  
  char* statement = "CREATE TABLE ONE(ID    INTEGER     PRIMARY KEY AUTOINCREMENT     NOT NULL, NAME           CHAR(50)    NOT NULL, LABEL         CHAR(50), GRP             CHAR(50), FILE         BLOB        );";
  
  rc = sqlite3_exec(database, statement, callback, 0, &amp;zErrMsg);
  sqlite3_close(database);
  </code></pre>
  
  <p>Which works perfectly, checked the database structure using SQLite Studio. Now I'm trying to insert anything by executing the following statement:</p>
  
  <pre><code>    int rc = sqlite3_open(dbname, &amp;database);
  char *zErrMsg = 0;
  
  char* statement = "INSERT INTO ONE(     ID,    NAME,    LABEL,    GRP,    FILE ) VALUES (     NULL,    'fedfs',    NULL,    NULL,    NULL);";
  
  rc = sqlite3_exec(database, statement, callback, 0, &amp;zErrMsg);
  
  
  sqlite3_close(database);
  </code></pre>
  
  <p>Which keeps throwing me SQLite error 1, "no such table: ONE". The database file does open correctly. Im out of ideas.</p>
  
  <p>Aside from that, I'm trying to figure out a way to open a PDF file using ifstream and store it as BLOB in SQLite. Is opening the file with ifstream the right way to store it as binary file?</p>