SQLite encoding problem

[cevou]

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:

QSqlQuery query;
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.

QSqlQuery query;
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

[Lykurg]

Hi, may it could help if you execute following

PRAGMA encoding = "UTF-8";

PRAGMA encoding = "UTF-8";

To copy to clipboard, switch view to plain text mode 

and did

SELECT name || surname FROM names WHERE nameid=?

SELECT name || surname FROM names WHERE nameid=?

To copy to clipboard, switch view to plain text mode 

also return a corrupt umlaut?

EDIT: what encoding has your cpp file?

[cevou]

Hi,

the first solution didn't work.

I think all the cpps are encoded using latin1.

[Lykurg]

and if you skip the blank in you "concat"? Is the umlaut then also corrupted? Seems to be a problem between your latin1-string and the internal utf8 of sqlite.