Page 1 of 1

What would I use

Posted: Fri Mar 24, 2006 1:45 pm
by Pineriver
Hi I am not as smart as you when it comes to setting up but I am upgrading my application to mysql and want to know what column types would I use for simple values like "true" or "false" ?

I'm thinking maybe like TINYTEXT but thats a type that can fit in 255 characters or less which would there be a more suidable smaller type for this? I wouldn't want the client mysql databases to become to huge.

Posted: Fri Mar 24, 2006 2:45 pm
by pickle
You can declare them as 'bool', which is just a shortcut to tinyint(1).

Posted: Fri Mar 24, 2006 2:56 pm
by infolock
you could also use ENUM('Y','N')

RE

Posted: Fri Mar 24, 2006 3:08 pm
by Pineriver
Thanks guys!