qt中使用sqlite [复制链接]

各位大侠，在sqlite数据库中怎么存储中文的数据？我的英文的数据和阿拉伯数据存储和查询都很正常

加tr，可以写进去的

是啊 ，中文数据是可以存储进去，但是读出来就是乱码了。不知道为什么啊？ （英文和阿拉伯数字存储和读出来都是正常的）
query.exec("create table alarm (id int primary key,"
                              "time TIMESTAMP ,"
           "diaochename varchar(20),"
           "alarmnumber varchar(20),"
           "jigouname varchar(20),"
           "content varchar(20),"
           "solution varchar(20),"
                              "status varchar(20) )");
                  query.exec("insert into alarm values(1,'2008-08-21T15:29:30','123', '中国','123','123','123','kk')");
                  query.exec("insert into alarm values(2, '2008-08-22T15:29:30','guide', '奥运','123','123','123','k')");
                  query.exec("insert into alarm values(3, '2008-08-23T15:29:30','wells', '习惯','123','123','123','C2')");
                  query.exec("insert into alarm values(4, '2008-08-24T15:29:30','zhang','中国','123','123','123', 'C')");
                  query.exec("insert into alarm values(5, '2008-08-25T15:29:30','andy','123', '123','123','123','d3')");
                  query.exec("insert into alarm values(6, '2008-08-26T15:29:30','wells', '123','123','123','123','Cf3')");

关注

谢谢各位的帮助，问题已经解决。解决如下就是二楼说的方案，加上tr就可以了，代码如下
query.exec("create table alarm (id int primary key,"
                              "time TIMESTAMP ,"
                             "diaochename varchar(20),"
                             "alarmnumber varchar(20),"
                             "jigouname varchar(20),"
                             "content varchar(20),"
                             "solution varchar(20),"
                              "status varchar(20) )"); 
                                       QString abcQuery = QObject::tr("insert into alarm values(1,'2008-08-21T15:29:30','123', '中国','123','123','123','kk')") ;
                      query.exec(abcQuery);
                     
                     
                                         query.exec(QObject::tr("insert into alarm values(2,'2008-08-21T15:29:30','123', '奥运','123','123','123','kk')"));
                  query.exec(QObject::tr("insert into alarm values(3, '2008-08-23T15:29:30','wells', '习惯','123','123','123','C2')"));
                  query.exec(QObject::tr("insert into alarm values(4, '2008-08-24T15:29:30','zhang','中国','123','123','123', 'C')"));
                  query.exec(QObject::tr("insert into alarm values(5, '2008-08-25T15:29:30','andy','火车', '123','123','123','d3')"));
                  query.exec(QObject::tr("insert into alarm values(6,'2008-08-21T15:29:30','123', '奥运','123','123','123','kk')"));