Sqlite3 string encoding problem

[curedream]

AA Table
a
1 192.168.1.1:8000

select a from aa

qry->values(0).toString() -> 192.168.1.1? error
QString::fromUtf8(qry->values(0).toByteArray()) -> 192.168.1.1:8000 ok

but i want into data to db

"insert into a values("192.168.1.1:8000")" -> save data 192.168.1.1?
tr("insert into a values("192.168.1.1:8000")").toUtf8 -> save data 192.168.1.1?

How can i do save 192.168.1.1:8000

plz help me.

[leon.anavi]

You might have syntax error at your SQL statement. Could you please explain again what kind of SQL statements do you want to execute and what problem do you have?

[Lykurg]

bq. insert into a values(...

According to what you have written a is a column, aa is the table. Please post real code!