[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...