Hi!

I am trying to read some German names from my sqlite database, and I have problems getting exact umlaut letters (Qt cuts of some bits wiht umlaut). This is my piece of code, where I am executing query:

QString sStatement = "SELECT rp.id, rp.FirstName, rp.LastName, rp.Alias, rp.eMail, rp.Phone, "
"rp.division, rp.comment "
"FROM tbl_Responsible rp "
"WHERE id = "
"("
"SELECT responsible_id FROM rel_TestCase_has_Responsible "
"WHERE testcase_id = :currentTcId"
") "
"ORDER BY rp.LastName ASC";

m_ResponsibleQuery.prepare(sStatement);
m_ResponsibleQuery.bindValue(":currentTcId", uiId);
m_ResponsibleQuery.exec();
QTextCodec::setCodecForCStrings(QTextCodec::codecF orName("UTF-8"));

if (checkForErrors(&m_ResponsibleQuery, "Error while fetching the testcase rel. responsibles!",parent))
return vResponsibles;
else
{
while(m_ResponsibleQuery.next())
{


vResponsibles.push_back
(
new Responsible
(
m_ResponsibleQuery.value(0).toInt(), //id
m_ResponsibleQuery.value(1).toString(), //firstName
m_ResponsibleQuery.value(2).toString(), //lastName
m_ResponsibleQuery.value(3).toString(), //alias
m_ResponsibleQuery.value(4).toString(), //eMail
m_ResponsibleQuery.value(5).toString(), //phone
m_ResponsibleQuery.value(6).toString(), //division
m_ResponsibleQuery.value(7).toString(), //comment
DBM_getTestCaseRelResponsibleFunctions
(
m_ResponsibleQuery.value(0).toInt(),
uiId,
parent
) // function
)
);
}
return vResponsibles;
}

Does anyone have suggestions what I should use to get correct names? Any replies are welcome

Thanx