SELECT lower('ТЕСТ');
SELECT upper('ТЕСТ тест TEXT');
SELECT 'Ы' LIKE 'ы';

CREATE VIRTUAL TABLE test USING fts4(content);
INSERT INTO test(content) values ('Тест');
SELECT upper('----------------------------');
SELECT snippet(test) FROM test WHERE test MATCH '*Тест*';
SELECT * FROM test WHERE content LIKE '%Тест%';
SELECT upper('----------------------------');
SELECT snippet(test) FROM test WHERE test MATCH '*тест*';
SELECT * FROM test WHERE content LIKE '%тест%';

D:\sqlite\bin\bin>sqlite3.exe < test.sql
тест
ТЕСТ ТЕСТ TEXT
1
----------------------------
<b>Тест</b>
Тест
----------------------------
Тест

D:\sqlite\bin\bin>