SQLite BLOB to QString

CryptixDE

I have a SQLite database with a field typed BLOB (Binary),
but this field contains normal text.
I want to have this field value as QString.
I already was able to get the value as ByteArray.

Here is my current code:

QSqlQuery query("SELECT value FROM Tabelle WHERE key='token'", db);
query.first();
QString data= query.value(0).toString();

But what I get is: "\""

mrjj

Hi
Did you try to convert to string via ByteArray ?
Here you do directly from QVariant

CryptixDE

How do I do this?
I searched for it but I couldn't find a way to do this via QVariant

Edit: Yes, I did, the SQLite result is aQVariant

mrjj

@CryptixDE
Hi
did not check if even possible but i meant like
QByteArray data= query.value(0).toByteArray();
QString datastr(data);

fsilva

This will depend a lot on the actual data that is present in the BLOB column ("text" can mean many many different things at the binary level).

But for a more generic case, something like this should work:

QByteArray strData = query.value(0).toByteArray();
QString str = QString::fromUtf8(strData);

CryptixDE

@mrjj Yea, I tried this, but this not returns the string for me, it just returns "\""

@fsilva Thank you, I'll try it asap :)

fsilva

You need to know the encoding of your string (I assumed UTF-8 but if you are getting only the quotation marks it's most likely UTF-16) and use the appropriate QString constructor or from**** static method.

CryptixDE

@fsilva so fromUtf16 instead of fromUtf8 should work?

CryptixDE

Yea, I solved this issue by using the hex value