the table named users has a field named hideemail, i think it should be a boolean field, but in fact its type is int(1), so why do u guys choose int(1), and not use bool type?
int(1) is cross database platform. We cater to other database platforms to MySQL too so we have to ensure we use data types available to all of them
(2012-07-11, 04:33 PM)euantor Wrote: [ -> ]int(1) is cross database platform. We cater to other database platforms to MySQL too so we have to ensure we use data types available to all of them
but i think most of the databases support bool type, so why u guys choose int(1)?
Because, not all databases support Boolean...
I'm not sure why you expect them to change their answer.
From memory, I think SQLite doesn't support boolean data types for fields.
IIRC, in MySQL bool is an alias for int(1)