I have this file which has non-printable characters (I've saved it in UTF-8 format): http://ift.tt/1UNI4FJ
Then I would like to load it into SQLite DB by this way (following this tip I've found: Check the encoding of text in SQlite):
PRAGMA encoding = "UTF-8";
CREATE TABLE TABLA (
NUMERO_REGISTRO INTEGER
, COLUM1 VARCHAR(6)
, COLUM2 VARCHAR(7)
, COLUM3 VARCHAR(7)
, COLUM4 VARCHAR(3)
, COLUM5 VARCHAR(30)
, COLUM6 VARCHAR(6)
, COLUM7 VARCHAR(2)
, COLUM8 VARCHAR(1)
, COLUM9 VARCHAR(7)
, COLUM10 VARCHAR(7)
, COLUM11 VARCHAR(7)
, COLUM12 VARCHAR(7)
, COLUM13 VARCHAR(7)
, COLUM14 VARCHAR(7)
, COLUM15 VARCHAR(7)
, COLUM16 VARCHAR(7)
, COLUM17 VARCHAR(1)
, COLUM18 VARCHAR(1)
, COLUM19 VARCHAR(3)
, COLUM20 VARCHAR(3)
, COLUM21 VARCHAR(30)
, COLUM22 VARCHAR(17)
, COLUM23 VARCHAR(15)
, COLUM24 VARCHAR(3)
, COLUM25 VARCHAR(3)
, COLUM26 VARCHAR(3)
, COLUM27 VARCHAR(3)
, COLUM28 VARCHAR(3)
, COLUM29 VARCHAR(12)
, COLUM30 VARCHAR(4)
, COLUM31 VARCHAR(4)
, COLUM32 VARCHAR(4)
, COLUM33 VARCHAR(4)
, COLUM34 VARCHAR(4)
, COLUM35 VARCHAR(4)
, COLUM36 VARCHAR(1)
, COLUM37 VARCHAR(2)
, COLUM38 VARCHAR(2)
);
.separator 'ww'
.import /home/llami/mifile.txt TABLA
But It returns the following when I run it under my RedHat Linux server:
$ sqlite3 dbname.db < /home/llami/loadit.sql
Error: /home/llami/mifile.txt line 1: expected 39 columns of data but found 10
I think is becouse it can't read the special characters and somehow it interprets them like the end of the record.
How could I import this file? I dislike the alternative of adding insert-into to the sql script becouse the real file I want to load has more than 2.000.000 records, so the performance is a very important point.
Aucun commentaire:
Enregistrer un commentaire