SQLite Forum

regexp for Unicode ranges
Is there a way with SQLite to match Unicode ranges such as Arabic, Greek, or Devanagari letters?

The following code returns zero rows

.load /usr/lib/sqlite3/pcre.so

select *
from (
select 'ascii' as name
select 'γλώσσα' as name
where name regexp '\p{Greek}';

The regex `[\u0621-\u064A0-9 ]` returns the error
`PCRE does not support \L, \l, \N{name}, \U, or \u (offset 3)`

I am using SQLite 3.31.1 on Ubuntu 20.04 with the package sqlite3-pcre version 0~git20070120091816+4229ecc-1.