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