SQLite Forum

regexp for Unicode ranges
Login
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
union
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.