Problems with getting boolean from db

[Angel Zaslavsky]

Hi,

The other problem I encountered is that I cannot get boolean data from MySQL database. This is how I tried to do that, assuming that conn is a valid connection:

MYSQL_RES *res;
MYSQL_ROW row;


mysql_query(conn, "SELECT name, sex FROM customers");
res = mysql_store_result(conn);
while (row = mysql_fetch_row(res))
{
printf("%s\n", row[0]);
}

The code above works fine for me, but it prints name fields only. If I try changing printf("%s\n", row[0]) to printf("%s\n", row[1]), it doesn't print the thing I need.

Field name is varchar, sex is bool. I'd like to know how can I get data from the sex field. I use Borland C++ 6 and MySQL C API for connecting.

Thanks in advance!