QTableView encoding problem

[SudaNix]

hello every body,

i have faced a problem in reading arabic data from MySQL database , that when i retrieved data ( with QSqlTableMode) and view it (with QTableView) i got un understandable text.

also the same problem appear when i use this code:

QSqlTableModel* model=new QSqlTableModel;
model->setTable("employees");
model->setHeaderData(0,Qt::Horizontal,"الرقم التسلسلي"); // here i hava used an arabic text in the header
model->select();
 
QTableView* view=new QTableView;
view->setModel(model);
view->show();

QSqlTableModel* model=new QSqlTableModel;
model->setTable("employees");
model->setHeaderData(0,Qt::Horizontal,"الرقم التسلسلي"); // here i hava used an arabic text in the header
model->select();

QTableView* view=new QTableView;
view->setModel(model);
view->show();

To copy to clipboard, switch view to plain text mode 

can any one help??

im using Linux and the charset for MySQL database is utf8.

[jacek]

i got un understandable text.

Does Qt use a font that contains arabic characters? Are you sure that data in the database is correct?

model->setHeaderData(0,Qt::Horizontal,"الرقم التسلسلي"); // here i hava used an arabic text in the header

By default Qt assumes that string literals are encoded in ISO-8859-1. Take a look at QTextCodec::setCodecForCStrings() and QTextCodec::setCodecForTr().

[SudaNix]

I think my qustion wasn't clear to be answered ..
so I'm gonna ask it again but in a clear language
...
I'm working in a Qt project with MySQL Database ... etc
I've stored data in Arabic in my database

when I populate my model with data from database and view it with QTableView
it appears in unknown language

so can I get any help over there plz

thanx in advance

[wysota]

I've stored data in Arabic in my database

How did you store the data? I mean... what exactly did you do and what application did you use?

[SudaNix]

firstly I'm using MySQL..
I've a table (EmployeeTable ) with fields ( ID, Name,Salary)

what I mean by ( I've stored data in Arabic in my database )
that I've typed some text in Arabic in Name field .. using this code :

QSqlQuery query;
query.exec("insert into EmployeeTable(ID,Name,Salary) values (1,'employee_name',300)");

QSqlQuery query;
query.exec("insert into EmployeeTable(ID,Name,Salary) values (1,'employee_name',300)");

To copy to clipboard, switch view to plain text mode 

but my employee_name in the above code is in Arabic Langauge like this:

QSqlQuery query;
query.exec("insert into EmployeeTable(ID,Name,Salary) values (1,'احمد',300)");

QSqlQuery query;
query.exec("insert into EmployeeTable(ID,Name,Salary) values (1,'احمد',300)");

To copy to clipboard, switch view to plain text mode 

the problem is.. when I populate my model with data from database and view it with QTableView it appears in unknown language. see this Code:

QSqlTableModel* model=new QSqlTableModel;
model->setTable("EmployeeTable");
model->select(); 
 
QTableView* view=new QTableView;
view->setModel(model);
view->show();

QSqlTableModel* model=new QSqlTableModel;
model->setTable("EmployeeTable");
model->select(); 

QTableView* view=new QTableView;
view->setModel(model);
view->show();

To copy to clipboard, switch view to plain text mode 

hope u got me..

[SudaNix]

jacek,,

I'll try it and feed you back ..
thanx for help

[jacek]

what I mean by ( I've stored data in Arabic in my database )
that I've typed some text in Arabic in Name field .. using this code :
....
QSqlQuery query;
query.exec("insert into EmployeeTable(ID,Name,Salary) values (1,'احمد',300)");

Then most likely the data in your database has bad encoding. Set encodings with setCodecForXxx() and insert the data again.

[SudaNix]

the problem is solved with this line:

QTextCodec::setCodecForCStrings(QTextCodec::codecForName("UTF-8"));

QTextCodec::setCodecForCStrings(QTextCodec::codecForName("UTF-8"));

To copy to clipboard, switch view to plain text mode 

thank u very mush jacek and wysota.