Checkbox mass update?
View Single Post
03-12-2008, 03:22 PM
Join Date: Apr 2007
Originally Posted by
I advise you to set the field to int(1) and put a 0 for no, and a 1 for yes. That way, the system would be more secure and you wouldn't have to mess with upper or lower case characters.
There is a
BOOLEAN / BOOL
data type which you can use, where zero is false and non-zero is true. Storing true/false values within an
column is a complete waste of space since that type uses four bytes. BOOL (or even TINYINT) only requires one byte. Specifying
restrict the range of allowed values to one byte in length (0-255 unsigned).
View Public Profile
Send a private message to Salathe
Visit Salathe's homepage!
Find More Posts by Salathe