QSqlQuery and umlaut

[Erni42]

Hi all,

just a question feature or bug.
I have a program with the routine

qquery.exec(query);
 ui->tableWidget->setItem(ui->tableWidget->rowCount() - 1, 2, new QTableWidgetItem(abfrage->value("start_nr").toString()))

compiling this with qt5.6.2 all umlaute shown correct, compiling with 5.8.x all umlaut and the ß are not displayed correctly. Do I have to set any value in 5.8?

Thanks,
Dietmar

[sneubert]

Hi Erni42,

can you tell the platform and the db you are using?

[Erni42]

Oh, yes sorry.

Platform is Window 10, Server remote Mysql 5.6.33

[sneubert]

Maybe it´s an encoding issue. Can you debug out the query result as QByteArray?

qDebug() << abfrage->value("start_nr").toByteArray();

[Erni42]

The character is splitted into 4 characters

"Neth\xC3\x83\xC2\xB6""fel"

[Erni42]

compiled with 5.6.x i got
"Neth\xC3\xB6""fel"

[Erni42]

Qt 5.9 alpha delivers also the correct result including the umlaut like ö

[the_]

@Erni42
Which encoding have you set in your database / table?

[Erni42]

Utf8_General_CI

The most anoying point is 5.6 is Wirkung 5.9 too. Just 5.8 returns wrong encoding vor something