QFile using utf-8

Hi

I'm having problem getting some data to .sql file.
I have got some data which has some format into SQL for MySql ..


It's working and every thing but, when you wan to show the data as french language.
it' does not...

In the .sql file you can see all the alphabet correctly.
but after you run the queries, and try to show the data. you see some of the results are not showing.

Is it because of the utf-8 .. I have changed the database to utf-8.
but how to change the file QFile to utf-8.

Regards

take a look at QTextStream::setCodec.

Hi Spirit.

Thanks a lot ..

Do you think this will do for file saving as will.

Code:

---

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

---

I have add this into the code as will.
I have Class which you set some data in it then you call getInsertSql() and
it will make the SQL statement .. i do not know if .toUtf8() will help.

Code:

---

out << property->getInsertSql().toUtf8() <<'\n';
out << property->getInsertEF().toUtf8()<<'\n';

---

After your replay I think this is the best.

Code:

---

QTextStream out(&sqlFile);
     out.setCodec(QTextCodec::codecForName("UTF-8"));

---

I hop it will work.

Thanks

Best Regards

Hi spirit,

Thank you ..
It did work. and even for a big scale

Quote:

---

Import has been successfully finished, 45678 queries executed.

---

and all with the correct view we need for this problem.

Best Regards