SQLite Forum

regexp for Unicode ranges
Login
Anonymous,

I have PCRE 8.39 based on this. The command `ldd /usr/lib/sqlite3/pcre.so` shows SQLite PCRE is linked against `/lib/x86_64-linux-gnu/libpcre.so.3` which comes from the package libpcre3 version 2:8.39-12build1.

You wrote you don't have a problem with straße, but I think we aren't talking about the same thing. I'm trying to match Unicode ranges. I can match the character ß by writing it, but I can't match all Greek characters using `\p{Greek}`

Here is another example

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

.mode csv
select *, name regexp '\p{Greek}', name regexp '\p{Latin}', name regexp 'ß'
from (
select 'ascii' as name
union
select 'γλώσσα'
union
select 'straße'
);
```

I get these results

```
ascii,0,1,0
"straße",0,1,1
"γλώσσα",0,1,0
```

But I am expecting


```
ascii,0,1,0
"straße",0,1,1
"γλώσσα",1,1,0
```

Do you get the latter?