decoding from utf8

[pcaeiro]

Hello,

i am working with Qt4 and MySql. All the tables in my database have "DEFAULT CHARSET=utf8", because i am writing in Portuguese and i need accents, in my cpp file i use:

res = QString::fromUtf8((const char*)r.data(), r.length());

res = QString::fromUtf8((const char*)r.data(), r.length());

To copy to clipboard, switch view to plain text mode 

and it works for most of the characters, but still i cant decode uppercase characters with accents like à or Ó.

Does any one know why?

Thanks in advance,

Paulo

[nish]

what is "r"? a bytearray? how do you get the result from db to bytearry?

[pcaeiro]

i do not know if its the right way to do it but it have worked for me, in the code lines above the qr its the QSqlQuery and r is a string, i use it to apply the fromUtf8 function that use a const char*.

QString s = qr.value(0).toString();
string r = s.toStdString();
res = QObject::fromUtf8((const char*)r.data());

QString s = qr.value(0).toString();
string r = s.toStdString();
res = QObject::fromUtf8((const char*)r.data());

To copy to clipboard, switch view to plain text mode 

For example:
The result will be fine for the word "são" but it will not work for "SÃO".

[nish]

why cant you just directly use "s"? .. it will contain the right charecters... QString already utf..

and r.data() return QChar and not char* so it is wrong..

[pcaeiro]

if i use,

QString s = qr.value(0).toString();
res = s;

QString s = qr.value(0).toString();
res = s;

To copy to clipboard, switch view to plain text mode 

the result for "SÃO GREGÓRIO" is "SÃO GREGÓRIO"

if i use,

QString s = qr.value(0).toString();
res = QString::fromUtf8((const char*)s.data(), s.length());

QString s = qr.value(0).toString();
res = QString::fromUtf8((const char*)s.data(), s.length());

To copy to clipboard, switch view to plain text mode 

the result for "SÃO GREGÓRIO" is "S" and 2 unprintable characters

in any of this two examples it does not work for lowercase characters.

if i use:

QString s = qr.value(0).toString();
string r = s.toStdString();
res = QString::fromUtf8((const char*)r.data(), r.length());

QString s = qr.value(0).toString();
string r = s.toStdString();
res = QString::fromUtf8((const char*)r.data(), r.length());

To copy to clipboard, switch view to plain text mode 

the result for "SÃO GREGÓRIO" is "S�?O GREG�?RIO"

and it works for lowercase characters (example: "são" results "são")

[numbat]

Try:

QByteArray b = qr.value(0).toByteArray();
res = QString::fromUtf8(b.constData(), b.length());

QByteArray b = qr.value(0).toByteArray();
res = QString::fromUtf8(b.constData(), b.length());

To copy to clipboard, switch view to plain text mode 

[wysota]

How about just:

QString s = qr.value(0).toString();
res = s;

QString s = qr.value(0).toString();
res = s;

To copy to clipboard, switch view to plain text mode 

Provided the appropriate column in the table is declared properly as a string column, Qt should automatically use the proper conversion.