Simon Slavin-3 wrote > On 13 May 2014, at 5:21pm, Constantine Yannakopoulos wrote: > >> ​This is very interesting Jan. The only way this could fail is if the >> collation implementation does something funny if it encounters this >> character​, e.g. choose to ignore it when comparing. > > That cuts out a very large number of collations. The solution works fine > for any collation which orders strings according to Unicode order. But > the point of creating a correlation is that you don't want that order. > > Simon.
Simon, I think that the most frequent point of making a collation is to get the Unicode order. At the bare minimum adding LIKE optimization to the ICU Sqlite extension would make sense, the savings are really huge. -- View this message in context: http://sqlite.1065341.n5.nabble.com/LIKE-operator-and-collations-tp73789p75667.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
