Hi Alex,

Welcome to sqlite.

Regarding:
sqlite> INSERT INTO 'gb' VALUES ('Die Alex','http://','Heisann Jungs!
\n\nIch drück euch alle meine Daumen für's finale!!  Ihr schafft das!!
\n\n','193.216.173.35','2007-
>
> 11-05 20:00:20',NULL);
>   ...> ;
>   ...> ;
>   ...> '
>   ...> ;
> SQL error: unrecognized token: "!!"
> sqlite>
>
================

I believe your problem is an unpaired single quote character caused by:
      für's
You'll want to escape the character as
      für''s                (two single quotes, apostrophes)


Regarding:   INSERT INTO 'gb' .....
   By the way, I think you'll want to use the DOUBLE quote character to
surround  identifiers such as "gb" -- or none at all for this particular
identifier.   The single quote is for literals.

Hope this helps,
   Donald
   Columbia SC USA
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to