Re: [sqlite] UTF8 LIKE stranges

Vlczech - Tomáš Volf wrote: > CREATE TABLE people ( > firstname TEXT, > surname TEXT > ); > INSERT INTO people('Tomáš', 'Surname'); > > "SELECT * FROM people WHERE firstname LIKE ?" > For binding I use: sqlite3_bind_text(stmt, 1, name.c_str(), -1, > SQLITE_STATIC); SQLITE_STATIC works only

[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

Sorry for "spam", I hope that previous HTML form of mail (with bullet lists) will be readable. There is, for sure and better readability for non-HTML clients, plain text version of previous mail:   Hello, I have some strange behaviout in LIKE query in SQLite. Letš see some very simplified