Mysql + QSqlTableModeil: incorrect locale

[blackliteon]

Hi!
I'm using CP-1251 on my Mysql local server.
So, when fileds contained russian characters, I only see "??????????????????"
What can i do to set locale? Maybe i need firstly say to mysql server "set locale ..." ?

[zlatko]

Use QTextcodec for convert your data to unicode.

[blackliteon]

Use QTextcodec for convert your data to unicode.

If I'm using SqlTableModel when we need call this function ?

[zlatko]

If I'm using SqlTableModel when we need call this function ?

sorry i used qt3 ...but i think next code will be helpful

QTextCodec *m_pCodec = QTextCodec::codecForName("CP1251");
 
// get data from recordset
QString str = m_pCodec->toUnicode(query.value(0).toString());

QTextCodec *m_pCodec = QTextCodec::codecForName("CP1251");

// get data from recordset
QString str = m_pCodec->toUnicode(query.value(0).toString());

To copy to clipboard, switch view to plain text mode 

[blackliteon]

sorry i used qt3 ...but i think next code will be helpful

QTextCodec *m_pCodec = QTextCodec::codecForName("CP1251");
 
// get data from recordset
QString str = m_pCodec->toUnicode(query.value(0).toString());

QTextCodec *m_pCodec = QTextCodec::codecForName("CP1251");

// get data from recordset
QString str = m_pCodec->toUnicode(query.value(0).toString());

To copy to clipboard, switch view to plain text mode 

Thanks for example!

[crocus]

http://prog.org.ru/forum/topic_2434.html