Re: [sqlite] INSERT failing.

2010-03-23 Thread Paul Corke
> unrecognized token: ""Man weiss es nicht, aber es war ein Feiertag.")" The character after the . is not a double-quote, plus you should be using single quotes anyway. Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] INSERT failing.

2010-03-22 Thread P Kishor
On Mon, Mar 22, 2010 at 11:59 PM, Ted Rolle wrote: > Here's the table definition: >  1  CREATE TABLE jokes ( >  2   source    TEXT, >  3   language  TEXT, >  4   question  TEXT, >  5   answer    TEXT >  6  ); > This works. > This doesn't: > INSERT INTO jokes > VALUES ("Radio

[sqlite] INSERT failing.

2010-03-22 Thread Ted Rolle
Here's the table definition: 1 CREATE TABLE jokes ( 2 sourceTEXT, 3 language TEXT, 4 question TEXT, 5 answerTEXT 6 ); This works. This doesn't: INSERT INTO jokes VALUES ("Radio Eriwan","de_DE","Frage an Radio Eriwan: An welchem Tag genau starb Josef Stalin?","Man