Re: [sqlite] Error: datatype mismatch

2014-02-28 Thread Richard Hipp
On Fri, Feb 28, 2014 at 8:00 AM, Dominique Devienne wrote: > Ran into this [datatype mismatch] error, which surprised me since I > thought SQLite's > dynamic typing allowed any value type to be stored in any column. > The exception to that rule is an INTEGER PRIMARY KEY

[sqlite] Error: datatype mismatch

2014-02-28 Thread Dominique Devienne
Ran into this error, which surprised me since I thought SQLite's dynamic typing allowed any value type to be stored in any column. Either the PK or the FK seem to have some influence (with pragma foreign_keys on or off), which I didn't expect, since the entered FK value does match the parent row's

Re: [sqlite] Error: datatype mismatch (Yanhong Ye)

2012-07-17 Thread Richard Hipp
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> CREA

Re: [sqlite] Error: datatype mismatch (Yanhong Ye)

2012-07-16 Thread YAN HONG YE
t;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;

Re: [sqlite] Error: datatype mismatch

2012-07-16 Thread Keith Medcalf
6 July, 2012 01:30 > To: sqlite-users@sqlite.org > Subject: [sqlite] Error: datatype mismatch > > the table is: > CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website varchar(50) > UNIQUE,userna > me varchar(50),password varchar(50)); > > and the txt file kk.txt is utf8:

Re: [sqlite] Error: datatype mismatch

2012-07-16 Thread Donald Griggs
On Mon, Jul 16, 2012 at 3:30 AM, YAN HONG YE wrote: > the table is: > CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website varchar(50) > UNIQUE,userna > me varchar(50),password varchar(50)); > > and the txt file kk.txt is utf8: > 0,nytime,gf,a1..7 > 1,bbc,1982,tbth432 >

[sqlite] Error: datatype mismatch

2012-07-16 Thread YAN HONG YE
the table is: CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website varchar(50) UNIQUE,userna me varchar(50),password varchar(50)); and the txt file kk.txt is utf8: 0,nytime,gf,a1..7 1,bbc,1982,tbth432 2,oknic,y...@sohu.com,bbaa1122 when I use " .import kk.txt webinfo" in cmd line I got the