[sqlite] UTF8 LIKE stranges

Hello, I have some strange behaviout in LIKE query in SQLite. Letš see some very simplified example:   Let's have a table CREATE TABLE people (   firstname  TEXT,   surname TEXT ); and in it following data: INSERT INTO people('Tomáš', 'Surname'); created by sqlite3_exec() function.     Then I

Re: [sqlite] UTF8 LIKE stranges

uot;: * "Tomä", but no longer with "Tomäš" * "Tomë", but no longer with "Tomëš" * "Tomö", but no longer with "Tomöš" * "Tomü" as well as "Tomüš"  Following national chars do not lead to select row name "Tomáš",