Re: MySQL Boolean vs. PostgresQL Boolean

2008-05-18 Thread Karen Tracey
On Fri, May 16, 2008 at 1:57 PM, Szaijan <[EMAIL PROTECTED]> wrote: > > Thanks Karen. > > Actually, the behavior here is worst case, from my perspective, in > that Ture/False values will update an instance, but will not be saved > and no exception is thrown. When I try to update the model with a

Re: MySQL Boolean vs. PostgresQL Boolean

2008-05-16 Thread Szaijan
Thanks Karen. Actually, the behavior here is worst case, from my perspective, in that Ture/False values will update an instance, but will not be saved and no exception is thrown. When I try to update the model with a True/False value, it simply fails to update without giving any indication of an

Re: MySQL Boolean vs. PostgresQL Boolean

2008-05-15 Thread Karen Tracey
On Thu, May 15, 2008 at 7:04 PM, Szaijan <[EMAIL PROTECTED]> wrote: > > I see it in my views. When I return the set and saved values for a > model, I get True or False from my app on the MacBook (Postgres) and 1 > or 0 from the exact same code on my Slicehost site (MySQL.) > > So, if I add someth

Re: MySQL Boolean vs. PostgresQL Boolean

2008-05-15 Thread Szaijan
I see it in my views. When I return the set and saved values for a model, I get True or False from my app on the MacBook (Postgres) and 1 or 0 from the exact same code on my Slicehost site (MySQL.) So, if I add something like: m = Model.objects.get(id=id) print m.boolean_field_name I get True/

Re: MySQL Boolean vs. PostgresQL Boolean

2008-05-15 Thread Carl Karsten
Szaijan wrote: > Hi, I developed my first Django app on my mapbook using PostgreSQL and > have recently moved it to a production site which uses MySQL. > PostgreSQL stores boolean values and True and False, just like Python > and JS, while MySQL uses 1 and 0. Where are you seeing this? I think y

Re: MySQL Boolean vs. PostgresQL Boolean

2008-05-15 Thread Scott Moonen
You should find that Django's BooleanField understands the difference between the databases and does the right thing. -- Scott On Thu, May 15, 2008 at 1:57 PM, Szaijan <[EMAIL PROTECTED]> wrote: > > Hi, I developed my first Django app on my mapbook using PostgreSQL and > have recently moved it

MySQL Boolean vs. PostgresQL Boolean

2008-05-15 Thread Szaijan
Hi, I developed my first Django app on my mapbook using PostgreSQL and have recently moved it to a production site which uses MySQL. PostgreSQL stores boolean values and True and False, just like Python and JS, while MySQL uses 1 and 0. Is there some automated way to get the models to understand