Mohd Radzi Ibrahim wrote: > It seems to works either way. > > I'm just wondering is there any hidden reason that single quote is > preferred? Portability? > Or is double-qoute has some kind of special meaning that we should use it > for that special purpose?
If what's enclosed in the double quotes winds up being a column name or other identifier, SQLite will treat it as an identifier rather than a literal. This can cause all sorts of unpleasant surprises, particularly of the "this was working fine until I made this cosmetic change..." sort. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
