Carl Karsten wrote: > Ed Leafe wrote: >> On Dec 15, 2006, at 7:46 PM, Carl Karsten wrote: >> >>> it actually reads "for int(): " and a square happy face looking >>> thing. guessing >>> it it some non printable char. >> Uh... is this part of the same problem dealing with bit fields? Or a >> completely new problem?
yup. and bit fields are not what I thought they were. I thought they were for booleans, but that is not the case. "BOOL, BOOLEAN These types are synonyms for TINYINT(1). A value of zero is considered false. Non-zero values are considered true. " I think BIT is meant for a bunch of flags. "BIT[(M)] A bit-field type. M indicates the number of bits per value, from 1 to 64. The default is 1 if M is omitted." Which is pretty much the same as an int, but a size is specified in bits. http://dev.mysql.com/doc/refman/5.1/en/numeric-type-overview.html > > I think I will create a sample db with a talbe that has just a PK and a bit. > I did. I'll post it as soon as I figure out the 'right' way to do mysql passwords. Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
