Mysql and Arabic encoding issue

[yazwas]

Hello everyone

I have a problem with MySQL and Arabic characters

I use the following line of codes to insert a record to a table

QString name ="يزن";
 
query.prepare("INSERT INTO stock (name, num) VALUES (:name, 10)" );
query.bindValue(":name", name);
query.exec();

QString name ="يزن";

query.prepare("INSERT INTO stock (name, num) VALUES (:name, 10)" );
query.bindValue(":name", name);
query.exec();

To copy to clipboard, switch view to plain text mode 

the record is entered successfully, although the name variable is changed to this 'Ã*Òä', as shown in the mysql browser

when I try to retrieve the record from the database, I get ??? displayed on the QLabel object

What should I do so that the value I enter to the database remains the same, i.e. يزن, and when I retrieve it, also displays correctly

Thanks alot for your help

[Tanuki-no Torigava]

Change charset using QSqlDatabase::setConnectOptions() during connection establishment to arabic. Should work.

[yazwas]

Hey Tanuki

Thanks for your reply

do you know the exact format for the mysql connection string option so that I can set it to Arabic charset (ISO8859_6)

I tried the following,

m_database.setConnectOptions("SET NAMES 'UTF8'");

m_database.setConnectOptions("SET NAMES 'UTF8'");

To copy to clipboard, switch view to plain text mode 

but I get the following error

QMYSQLDriver:: open: Unknown connect option 'SET NAMES 'UTF8''

Thanks in advance

[Rembobo]

If UTF-8 encoding is used in the code source .
Try

QString name = QString::fromUtf8("يزن");

QString name = QString::fromUtf8("يزن");

To copy to clipboard, switch view to plain text mode 

By default QString assumes that such strings have ASCII encoding.

QString ctor
setCodecForCString

[yazwas]

Thanks all

its solved using the following line

QTextCodec::setCodecForCStrings(QTextCodec::codecForName("CP1256") );

QTextCodec::setCodecForCStrings(QTextCodec::codecForName("CP1256") );

To copy to clipboard, switch view to plain text mode 

and then, I use the same code as before

QString name ="يزن";
 
query.prepare("INSERT INTO stock (name, num) VALUES (:name, 10)" );
query.bindValue(":name", name);
query.exec();

QString name ="يزن";

query.prepare("INSERT INTO stock (name, num) VALUES (:name, 10)" );
query.bindValue(":name", name);
query.exec();

To copy to clipboard, switch view to plain text mode 

and the value is saved as يزن and retrieved as يزن

Thanks again

[coloradorockies]

My advice is to use UTF-8 it's universal encoding. And run SET NAMES 'utf8'; after connecting to DB:

$link = mysql_connect('host', 'user', 'password');
mysql_query('SET NAMES utf8', $link);

$link = mysql_connect('host', 'user', 'password');
mysql_query('SET NAMES utf8', $link);

To copy to clipboard, switch view to plain text mode 

Make sure you back up the database