[sqlalchemy] Re: Boolean, Declerative, MySQL 5.2

[Bobby Impollonia]

I am using Column(Boolean) with declarative and MySQL and it is
working fine. In MySQL itself the type is 'tinyint(1)' but they
provide 'bool' and 'boolean' as synonyms if you prefer.

On Sat, Jul 19, 2008 at 7:48 AM, Heston James - Cold Beans
[EMAIL PROTECTED] wrote:
 Hello Guys,



 I'm looking to store a Boolean value in a MySQL 5.2 database. I'm then going
 to describe a class for the table using declarative and have a couple of
 questions on this:



 What Datatype should my table column be set to in MySQL? And likewise, when
 declaring the column using declarative, which data type should I use?



 Column(Boolean)?



 Cheers guys,



 Heston

 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---

[sqlalchemy] Re: Boolean, Declerative, MySQL 5.2

[Heston James - Cold Beans]

 I am using Column(Boolean) with declarative and MySQL and it is
 working fine. In MySQL itself the type is 'tinyint(1)' but they
 provide 'bool' and 'boolean' as synonyms if you prefer.

Bobby,

Thank you for this, I went with the tinyint(1) and it seems to be working
great!

Thanks,

Heston


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---