title: SQLite INSERT command return error "column number is not unique"
body: <p>I have a text file with rows (lines). Each row is a record in database table. I read this file and fill database.</p>
  
  <p>Tables creating command:</p>
  
  <pre><code>CREATE TABLE gosts(number TEXT PRIMARY KEY, userNumber TEXT, status TEXT, date TEXT, title TEXT, engTitle TEXT, description TEXT, mainCategory INTEGER, category INTEGER, subCategory INTEGER);
  </code></pre>
  
  <p>Inserting query:</p>
  
  <pre><code>INSERT INTO gosts VALUES ("30331.8-95", "ÃÎÑÒ 30331.8-95", "Äåéñòâóþùèé", "01.07.1996", "Ýëåêòðîóñòàíîâêè çäàíèé. ×àñòü 4. Òðåáîâàíèÿ ïî îáåñïå÷åíèþ áåçîïàñíîñòè. Îáùèå òðåáîâàíèÿ ïî ïðèìåíåíèþ ìåð çàùèòû äëÿ îáåñïå÷åíèÿ áåçîïàñíîñòè. Òðåáîâàíèÿ ïî ïðèìåíåíèþ ìåð çàùèòû îò ïîðàæåíèÿ ýëåêòðè÷åñêèì òîêîì", "Electrical installations of buildings. Part 4. Protection for safety. Applisation of protective measues for safety. Measures of protection against electric shock", "Íàñòîÿùèé ñòàíäàðò óñòàíàâëèâàåò îáùèå òðåáîâàíèÿ ïî ïðèìåíåíèþ ìåð çàùèòû äëÿ îáåñïå÷åíèÿ áåçîïàñíîñòè è òðåáîâàíèÿ ïî ïðèìåíåíèþ ìåð çàùèòû îò ïîðàæåíèÿ ýëåêòðè÷åñêèì òîêîì ïðè ýêñïëóàòàöèè ýëåêòðîóñòàíîâîê çäàíèé", 37, 333, 628);
  </code></pre>
  
  <p>Please ignore encoding problems. Source file has cp1251 encoding, but inserting sample is taken from console. I tried to use utf-8 but had the same problem.</p>
  
  <p>SQLite using code above:</p>
  
  <pre><code>if(sqlite3_prepare_v2(database, query, -1, &amp;statement, 0) == SQLITE_OK) {
  ...
  }
  </code></pre>
  
  <p>Function calling doesn't return SQLITE_OK. And I gea error message by:</p>
  
  <pre><code>string error = sqlite3_errmsg(database);
  if(error != "not an error") cout &lt;&lt; query &lt;&lt; " " &lt;&lt; error &lt;&lt; endl; 
  </code></pre>
  
  <p>Strangely, some records are inserted without error and I can't find differences between good and bad records.</p>
  
  <p>I can provide more information if needed.</p>