SQLite encoding problem

[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.