[Answer]-Truncated incorrect DOUBLE value: 'True'

by

1👍

✅

A tinyint column doesn’t accept booleans, convert the boolean to an integer:

intvalue = int(boolean_value)

to store 0 or 1 for False and True, respectively.

In the other direction, 0 and 1 test as false and true in boolean contexts, so you don’t have to convert them back. You can still do so if you want, with bool().

👤Martijn Pieters

Leave a comment