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 if the name variable is not modified or destroyed
before the query is finalized. Otherwise, use SQLITE_TRANSIENT.
> The problem is, that row with name "Tomáš" is selected also by following
> strings (with CZ national chars) in variable name used in sqlite3_bind_text:
> * "Tomě", but no longer with "Toměš"
I cannot reproduce this.
Are you sure that you have used the UTF-8 encoding correctly?
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
