To quote a string in SQLite use apostrophes. This refers to a five character
string:
'black'
If you surround something with double quotes SQLite understands it as an entity
name. Entities are things like tables and columns. So this is understood to
be a column name:
"black"
. Because SQLite was originally written to handle such strings it manages to
interpret
insert into competitors values (1109,"SERHAN", "James");
correctly instead of giving an error message. However this construction
WHERE competitors.last="WHITE"
probably doesn't mean what you think it means.
In future it might be a good idea to avoid column names which you might use a
values. That way you're less likely to encounter the problem.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
