> Just a simple question (I think).
> When should I use tinyint over int. and what is the difference between the
> two?

MySQL manual section 7.3 (data types):
    tinyint (8bit), range is
        0 to 255 (unsigned)
        -128 to 127 (signed)
    int (32bit), range is
        0 to 4294967295 (unsigned)
        -2147483648 to 2147483647 (signed)

Basically, only use tinyint if you are desperate to
save some space and you know a value will never,
ever be outside its range; otherwise use int.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to