mySQL data types

[dror_israel]

Hello,

What mySQL data types I need to use for the followings:
1) ID Field (Auto numbering)
2) Text field (with text size limit)
3) Free text field (with no text size limit)
4) Radiobutton options (bit, only 0 or 1)

I think thats all but if you think I should know more things please tell me.

Thanks

[WindomEarle]

Originally posted by dror_israel
Hello,

What mySQL data types I need to use for the followings:
1) ID Field (Auto numbering)
2) Text field (with text size limit)
3) Free text field (with no text size limit)
4) Radiobutton options (bit, only 0 or 1)

I think thats all but if you think I should know more things please tell me.


Thanks

1. tinyint or int, depends on how many records will you have.
2. limit = ? varchar has limit 255. Personaly I use text type
3. maybe longtext
4. tinyint (i'm not sure for this. Maybe there are better one)