Charset: latin1 in MySQL Why?

[Mauricio]

Hi everyone

I have a problem with a mysql connection, in my code:

if(QSqlDatabase::isDriverAvailable("QMYSQL")){
        QSqlDatabase myDB = QSqlDatabase::addDatabase("QMYSQL");
        myDB.setHostName(S);
        myDB.setUserName(U);
        myDB.setPassword(P);

if(QSqlDatabase::isDriverAvailable("QMYSQL")){
        QSqlDatabase myDB = QSqlDatabase::addDatabase("QMYSQL");
        myDB.setHostName(S);
        myDB.setUserName(U);
        myDB.setPassword(P);

To copy to clipboard, switch view to plain text mode 

Whe I try to connect, I use Wireshark and I see that:

SnapCrab_NoName_2014-6-4_20-55-13_No-00.png

How I can change this? I wanna use UTF8 but I don't know how do this.

Please, anybody can help me?


Regards.

[ChrisW67]

Take a look at the [client] section in your my.cnf file for a "default-character-set=utf8" entry. Where that config lives is dependent on your environment (and there are several places the client might look).