At 22:36 18/05/2014, you wrote:
The more I
think of it, though, I think that the solution is as simple as converting
all letters to lower(/upper) case and converting all whitespace to a
single
space each, except for within matching [ ], " ", ' ' or ` `. After that, I
can do a memcmp().
You're lucky that SQLite natively accepts Unicode schema names but is
only case-insensitive over the 7-bit ASCII charset range, even when the
ICU extension is built-in.
Requirement R-26223-47623-19728-21792-34687-27643-09360-29816
Like other SQL identifiers, database names are case-insensitive.
(source <http://www.sqlite.org/lang_naming.html>lang_naming.html,
checked-by: tcl/e_resolve.test)
from http://www.sqlite.org/requirements.html is ambiguous and misleading.
CREATE TABLE ÉTUDE (a CHAR); -- works
SELECT * FROM étude; -- no such table étude
SELECT * FROM Étude; -- works
(I hope my E and e with acute accents show up on your side)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users