BOOLEAN is an ANSI-SQL data type. Atleast since SQL99 it is a supported-type. Other than Oracle, I think every database vendor support BOOLEAN, by that name or BIT type.
yes, liquibase has a boolean that will be converted to the correct type that the database supports. --- Regards, Saptarshi PURKAYASTHA My Tech Blog: http://sunnytalkstech.blogspot.com You Live by CHOICE, Not by CHANCE On 29 August 2011 17:33, Darius Jazayeri <[email protected]> wrote: > There is no standard sql boolean type though right? Last time I used oracle > we used char(1) for example. > > Does liquibase have a virtual boolean type? > > -Darius (by phone) > > On Aug 29, 2011 7:40 AM, "Saptarshi Purkayastha" <[email protected]> wrote: > > The standard to do that is by making it '0' which even MySQL accepts. with > quotes, the standard is to use FALSE. > I would like to have the columns as BOOLEAN instead of int because that's > what it actually is supposed to be and we should leave it upto the database > server to store however it wants to. > > More can be seen here: > http://www.postgresql.org/docs/9.0/static/datatype-boolean.html > > > > --- > Regards, > Saptarshi PURKAYASTHA > > My Tech Blog: http://sunnytalkstech.blogspot.com > You Live by ... > > On 29 August 2011 11:48, Ben Wolfe <[email protected]> wrote: > > > > The changes should be down at the db... > > ________________________________ > Click here to unsubscribe from OpenMRS Developers' mailing list > > _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
