Re: Need help retrieving boolean value using MySQLdb

[Geert Vanderkelen]

Hello Danial,

First, in MySQL, the BOOLEAN data type is a synonym for TINYINT(1). Quoting the manual:
"These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered"

If your column preprogramUpdate is of any numeric type, you might want something like this:

if rows[0]:
preprogram_update = True
else:
preprogram_update = False


Cheers,
Geert

Geert Vanderkelen
Software Developer at Oracle