it seems apparent that data that isn’t in the range (None, 0, 1) is getting into that column, that’s the part you’d need to fix.
Or make yourself a custom type that interprets whatever number it is you’re putting in there as a boolean. On Oct 28, 2013, at 10:34 AM, Gustavo Gawryszewski <gustavoga...@gmail.com> wrote: > Well, it happened again after i've added some data to my database. > > I'm using sqlalchemy 0.8.3 and pymysql 0.6.1. (I have also tried with > mysql-python 1.2.4) > > On Fri, Oct 25, 2013 at 3:33 PM, Michael Bayer <mike...@zzzcomputing.com> > wrote: >> >> On Oct 25, 2013, at 12:59 PM, Gustavo Gawryszewski <gustavoga...@gmail.com> >> wrote: >> >> >> I've got an error while trying to retrieve boolean items from mysql. >> >> as stated in >> http://stackoverflow.com/questions/19591801/sqlalchemy-cant-convert-boolean-to-int-with-mysql >> >> but when I've installed without the C Extensions everything worked fine. >> >> Is that a bug? >> >> >> can’t reproduce, please see http://stackoverflow.com/a/19596096/34549 >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at http://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at http://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/groups/opt_out. > > > > -- > Gustavo Gawryszewski > Founder & Principal Designer > www.bekind.com.br > > Mobile: +55 51 9456-4554 > Website: http://gawry.com > LinkedIn: http://www.linkedin.com/in/gawry > Twitter: http://twitter.com/gawry > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.