Simon Slavin <[email protected]> wrote: > On 18 Sep 2009, at 9:07pm, Roger Binns wrote: > >> Simon Slavin wrote: >>> * Unicode support from the ground up >> >> SQLite already has "unicode support from the ground up". Try using >> non-Unicode strings and you'll see! > > SQLite's indexing correctly understands how to order Unicode > strings ?
With ICU extension enabled and correct collation specified, yes. Note that the correct ordering of Unicode strings is locale-dependent. > It can do upper- and lower-case ordering in languages like > Hebrew ? To the best of my knowledge, Hebrew doesn't have the notion of case. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
