QFile using utf-8

[Mr.QT]

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

[spirit]

take a look at QTextStream::setCodec.

[Mr.QT]

Hi Spirit.

Thanks a lot ..

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

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

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

To copy to clipboard, switch view to plain text mode 

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.

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

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

To copy to clipboard, switch view to plain text mode 

After your replay I think this is the best.

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

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

To copy to clipboard, switch view to plain text mode 

I hop it will work.

Thanks

Best Regards

[Mr.QT]

Hi spirit,

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

Import has been successfully finished, 45678 queries executed.

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

Best Regards