On Mon, Jul 16, 2012 at 9:29 PM, YAN HONG YE <yanhong...@mpsa.com> wrote:
> I know the reason: > if I change the file encode to latin, it will suecess import the data; > but when I change the txt file to utf8 encode, It will get the error: > Error: datatype mismatch > I wanna know how to import utf8 encode file to my database? > Your easiest solution would be to run your script on either Mac or Linux. > > >Date: Mon, 16 Jul 2012 02:19:12 -0600 > >From: "Keith Medcalf" <kmedc...@dessus.com> > >To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > >Subject: Re: [sqlite] Error: datatype mismatch > >Message-ID: <e490d863a81fdc4cbf3bf970f3c0b...@mail.dessus.com> > >Content-Type: text/plain; charset="us-ascii" > > > > > >sqlite> CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website > varchar(50) UNIQUE,username varchar(50),password varchar(50)); > >sqlite> .mode csv > >sqlite> .import kk.txt webinfo > >sqlite> select * from webinfo; > >0,nytime,gf,a1..7 > >1,bbc,1982,tbth432 > >2,oknic,y...@sohu.com,bbaa1122 > >sqlite> > > > >Did you forget to say ".mode csv"? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
