Hello I'm trying to import some TAB-separated records from a Windows host into a Linux host, but it fails with "Error: datatype mismatch":
1. On Windows, converted file from Windows to Unix (ie. CRLF -> LF) 2. On Linux, download test.csv, and ran "sqlite3 db.sqlite" 3. sqlite> .schema CREATE TABLE customer (id INTEGER PRIMARY KEY AUTOINCREMENT, tel VARCHAR(32), name VARCHAR(255)); CREATE INDEX index_tel ON customer (tel); sqlite> .separator "\t" sqlite> .import test.csv customer Error: datatype mismatch I've tried the following formats, to no avail: NULL\t123-1234\tJohn Doe\n \t123-1234\tJohn Doe\n Any idea why SQLite fails importing this type of records? Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
