torque/mysql/boolean??

[philipina]

Hello,

I'm using apache torque to generate my mysql database layout.
In my torque definition I have some field defined as BOOLEAN.
As mysql does not supported boolean, torque generates a layout by replacing boolean by INTEGER.
The problem is that after creating my DB, if I do a dump and open my dump file I can see that this fields are marked as INT(11).
I don't understand why it is INT(11) and not INT(1). Is is a default value?

Thanks in advance for your explanations.

-------------------------
Philipin Alain

http://www.BiereMaison.be

-------------------------

 

[r937]

for numeric datatypes, the number in parentheses has nothing to do with the size of the column

INT(1) can hold exactly the same range of numbers as INT(10) or INT(937)

for boolean, you'd want TINYINT

r937.com | rudy.ca

 

[philipina]

Ok, then I have to check why torque is setting it to INT instead of TINYINT.

Thank you.

-------------------------
Philipin Alain

http://www.BiereMaison.be

-------------------------