Is not working

[Ваня Берлинец]

SELECT 'ФУНТ СВЯТОЙ ЕЛЕНЫ' LIKE 'ЛЕ' || '%' COLLATE NU900_NOCASE

[Aleksey Tulinov]

I don't think it should work like that. Pattern is missing "%" at start implying string need to start from "ЛЕ" and might have any characters after it.

sqlite> SELECT 'ФУНТ СВЯТОЙ ЕЛЕНЫ' LIKE 'ЛЕ' || '%' COLLATE NU900_NOCASE;
0
sqlite> SELECT 'ЛЕНЫ' LIKE 'ЛЕ' || '%' COLLATE NU900_NOCASE;
1
sqlite> SELECT 'ФУНТ СВЯТОЙ ЕЛЕНЫ' LIKE '%ЛЕ' || '%' COLLATE NU900_NOCASE;
1

[Ваня Берлинец]

sorry, after commit 0a80e83 it's worked.

[Ваня Берлинец]

sqlite> SELECT 'ФУНТ СВЯТОЙ ЕЛЕНЫ' GLOB 'ф' || '*' COLLATE NU900_NOCASE;
0
sqlite> SELECT 'ФУНТ СВЯТОЙ ЕЛЕНЫ' GLOB 'Ф' || '*' COLLATE NU900_NOCASE;
1

[Aleksey Tulinov]

1. GLOB is not currently supported in nunicode's SQLite extension because no one requested this before. Please refer to extension description: https://bitbucket.org/alekseyt/nunicode#markdown-header-sqlite3-extension . Supported functions are:

• upper(X)
• lower(X)
• X LIKE Y ESCAPE Z
• COLLATE NU900 - case-sensitive Unicode collation
• COLLATE NU900_NOCASE - case-insensitive Unicode collation

2. GLOB is case-sensitive, therefore SELECT 'ФУНТ СВЯТОЙ ЕЛЕНЫ' GLOB 'ф*' is supposed to return 0 i believe
3. To my knowledge COLLATE NU900_NOCASE has no effect on GLOB or LIKE (LIKE is case-insensitive) due to the fact that GLOB and LIKE has their own case-sensitivity rules

[Aleksey Tulinov]

sqlite> SELECT 'ФУНТ СВЯТОЙ ЕЛЕНЫ' GLOB upper('ф') || '*';
1

Hope this helps

[Ваня Берлинец]

Yes, thanks.