On Fri, 4 Feb 2022 at 13:21, Les <nagy...@gmail.com> wrote: > >> What if you try applying the C collation to the values from the table: >> >> where fi.is_active and fi.relpath collate "C" ^@ 'A' > > > Slow
What about this:
fi.relpath between ('A' collate "C") and ('A'||chr(255) collate "C")
