Problem with encoding (INSERT) in oracle db on windows



  • Hello,
    I try to insert string with accent like "essais à" in an oracle 11g.
    @
    QSqlQuery query(db);
    query.prepare(QString("INSERT INTO TRADUCTION_TEXTE "
    "VALUES (:texte_original, 1, :traduction)") );

        query.bindValue( QString(":texte_original"), "essais à"  );
        query.bindValue( QString(":traduction"), "try to");
        query.exec();
    

    @

    but the insertion is not correct and i have some é caracters, due to incorrect encoding i guess (I am on windows)
    Does someone happen to have some idea to correct this?

    Thanks in advance.



  • try query.bindValue( QString(":texte_original"), tr("essais ") );


Log in to reply
 

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