Mysql + QSqlTableModeil: incorrect locale

**blackliteon** · 10th February 2006, 09:56

Originally Posted by zlatko

Use QTextcodec for convert your data to unicode.

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

**zlatko** · 10th February 2006, 10:15

Originally Posted by blackliteon

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

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

Qt Code:

Switch view

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** · 10th February 2006, 10:40

Originally Posted by zlatko

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

Qt Code:

Switch view

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** · 10th February 2006, 16:07

Thread: Mysql + QSqlTableModeil: incorrect locale