Hi all.

I have a little problem when it's come to insert a japanese caracter into my SQlite database :

With the following code :

Qt Code:
  1. QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
  2. db.setDatabaseName("test.db");
  3.  
  4. if (!db.open()) {
  5. QMessageBox::critical(0, qApp->tr("Cannot open database"),
  6. qApp->tr("Unable to establish a database connection.\n"
  7. "This example needs SQLite support. Please read "
  8. "the Qt SQL driver documentation for information how "
  9. "to build it.\n\n"
  10. "Click Cancel to exit."), QMessageBox::Cancel);
  11. }
  12.  
  13. QSqlQuery query;
  14.  
  15.  
  16. query.exec("create table kanji (id int primary key, "
  17. "kanji nvarchar, "
  18. "signification nvarchar)");
  19.  
  20. query.exec("insert into kanji values(0, '<all>', '0')");
  21. query.exec("insert into kanji values(1, '日', 'Soleil')");
  22. query.exec("insert into kanji values(2, '火', 'Feu')");
  23. query.exec("insert into kanji values(3, '水', 'Eau')");
  24.  
  25. model->setTable("kanji");
  26. model->setEditStrategy(QSqlTableModel::OnManualSubmit);
  27. model->select();
  28. model->removeColumn(0);
  29. model->setHeaderData(0, Qt::Horizontal, tr("Kanji"));
  30. model->setHeaderData(1, Qt::Horizontal, tr("Signification"));
  31.  
  32. QTableView *view = new QTableView;
  33. view->setModel(model);
  34. view->show();
To copy to clipboard, switch view to plain text mode 

In result i have this:



I'm running under Qt Open source. Thanks you in advance