Dear friends,

I'm developing a program using C++ and SQLite3 as database. I have a problem with encoding when I try to execute a SQL query with some characters like "ñ, á, é, í, ó, ú". My db is UTF-8 encoded and when I'm debugging I can see that the sentence is right but I have no result. However, when I try to execute the same sentence by using the SQLite3 console I have no problem.

E.g. "SELECT devices FROM room WHERE name_room='baño'" => it works in SQLite3 console but not using the API.

Do you know how to solve it?

Thanks in advance.
----
Pedro Vivancos
University of Murcia. Spain

Reply via email to