Dominique Devienne wrote
> On Tue, May 13, 2014 at 5:50 PM, Jan Slodicka <
> jano@
> > wrote:
>> So one could replace "LIKE 'xxx%'" by "BETWEEN('xxx', 'xxx' +
>> '\uDBFF\uDFFD').
>
> make that
>
> BETWEEN('xxx', 'xxx' + char(1114109))
>
> I don't think SQlite supports \uFFFF literals, nor does it support hex
> literals, so must use the decimal equivalent to U+10FFFD.
Dominique,
I just wanted to sketch the idea and did not care of the syntax. I am going
to apply this differently, anyway:-)
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/LIKE-operator-and-collations-tp73789p75665.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
