On 12 Jun 2012, at 9:52am, rick <jansm...@xs4all.nl> wrote: > Well, I'm not entirely a casual user, but I don't know the SQL-92 standard > or it's successors. I'm an engineer, and sqlite for me is a tool. Above > query was used a long time in a MySQL DB, where it works as (I) expected.
SQL (note that I'm talking about the same SQL-92 standard Larry referred to) does not use the same convention of double-quoting text strings that you are used to from other programming languages. It's something you need to get used to when using SQL no matter which SQL engine you use. MySQL's use of double quotes is something special for MySQL, not normal for SQL. We used to have to deal with different string quoting rules for FORTRAN, COBOL, ALGOL, BASIC, PASCAL, and LISP. Now almost everything uses non-directional double-quotes. Kids these days have it easy. And get off my lawn. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users