Hi everyone,
I have a problem with selecting German umlauts (ä ö ü) from an SQLite-Database.
There is one thing that works an another that doesn't.
Here the working example:
query.prepare("SELECT name, surname FROM names WHERE nameid=?");
...
QSqlQuery query;
query.prepare("SELECT name, surname FROM names WHERE nameid=?");
...
To copy to clipboard, switch view to plain text mode
This return for example "Max" and "Müller".
BUT if I want to select it in one combined string like this it returns some strange characters.
query.prepare("SELECT name || ' ' || surname FROM names WHERE nameid=?");
...
QSqlQuery query;
query.prepare("SELECT name || ' ' || surname FROM names WHERE nameid=?");
...
To copy to clipboard, switch view to plain text mode
In my case this returns "Max M?ller". It's the same dataset just a differen SELECT. What am I doing wrong?
Thanks in advance
Chris
Bookmarks