[SOLVED] How to convert char from SQL into QChar?

MisteKiste

Hello,

I got a SQL Database with char field. Now i want to fetch the char field and convert it into QChar. But it doesn't really work. I tried to convert with
@
.toChar
@

Shouldn't it work? It returned always
@0 '\0'@

How to convert char from SQL correctly into QChar?

JKSH

Hi,

Can you show your code that fetches the char from the SQL database?

MisteKiste

Yes.

@

QSqlQuery query;
query.prepare(queryStatement);
int field_Cgender = query.record().indexOf("Cgender");

while ( query.next() )
{
PointsWeightsMD * obj_Result = new PointsWeightsMD();

    obj_Result->c_Gender = query.value(field_Cgender).toChar();

    objs_Result.append(obj_Result);
}

@

But I think thats not a Database problem. I can fetch the other fields without problems.

JKSH

Is the value of field_Cgender correct?

What is the raw value and type retrieved from the query?

@
#include <QDebug>

...

while ( query.next() )
{
qDebug() << field_Cgender << query.value(field_Cgender);
}
@

MisteKiste

This is the output:

bq. 3 QVariant(QString, "m")bq.

Thats weird. Why its a QString? In Database its stored as char...

JKSH

What type of SQL implementation is it? (SQLite? SQL Server? PostgreSQL? Something else?) In all the implementations I've seen, CHAR is designed for storing character arrays (which means they store strings). For example, see http://dev.mysql.com/doc/refman/5.0/en/char.html

MisteKiste

I'm using SQLite. So when I'm fetching data with SQL Statement I have to store it in a QString variable and after that I can convert into QChar?
Well that is exactly what I'm doing here or not?
@obj_Result->c_Gender = query.value(field_Cgender).toChar();@

Edit:
Ok...weird...I can't even edit the value of c_Gender in Debug modus. Its always 0. Can somebody explain why?

MisteKiste

Has nobody an idea? :(

clochydd

Hi,
JKSH already stated, that the SQL Database stores CHAR as strings.
Working with Postgres I read all CHAR, VARCHAR, TEXT into QString and never had a problem with that.
In your case:
@
obj_Result->c_Gender = query.value(field_Cgender).toString();
@
You should then be able to convert the QString into QChar.
Hope it helps...

andre

SQLite doesn't even distinguish between column types. Not really.

If you want the char from your string, just use

@
QString str_Result->c_Gender = query.value(field_Cgender).toString();
QChar obj_result;
if (!str_Result.isEmpty()) {
obj_result = str_Result[0];
}
@

MisteKiste

Thanks guys that helped me a lot. I thought it just works with .toChar...