Sqlite3 string encoding problem



  • 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.



  • 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?



  • bq. insert into a values(...

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


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.