SQLite reading Chinese strings issue

[yazwas]

Good day

I have a sqlite table that has a simplified Chinese column, and I want to preview that table in QSqlTableModelI was able to print Chinese characters to the label using the following code

QTextCodec::setCodecForCStrings(QTextCodec::codecForName("GB2312"));
QString a= "T氓颅鈥斆ヂ嘎";
ui->label->setText(a);

QTextCodec::setCodecForCStrings(QTextCodec::codecForName("GB2312"));
QString a= "T氓颅鈥斆ヂ嘎";
ui->label->setText(a);

To copy to clipboard, switch view to plain text mode 

and it shows OK, so I think the issue is when reading from the db. I've tried SQLite administrator tool and it shows the table with the Chinese entries OK

What do you think a solution to this issue is?

Thanks!

[yazwas]

I fixed this by using the following

QTextCodec::setCodecForCStrings(QTextCodec::codecForName("GB18030"));     //gb18030 was the encoding of the data.
 
//then using a query to retrieve the data, and display like below
QString str = query.value(0).toString().toUtf8();   //this would show a correct encoding of the data!

QTextCodec::setCodecForCStrings(QTextCodec::codecForName("GB18030"));     //gb18030 was the encoding of the data.

//then using a query to retrieve the data, and display like below
QString str = query.value(0).toString().toUtf8();   //this would show a correct encoding of the data!

To copy to clipboard, switch view to plain text mode