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