Benjamin Pflugmann writes:
> Hi. > > On Tue, Oct 02, 2001 at 09:33:53AM +0000, [EMAIL PROTECTED] wrote: > [...] > > I've seen rumors about bool being an alias for tinyint(1), but it's > > not in the manual and I haven't tested it. > > Actually, it's in the manual (but just recently ;), but it tells > otherwise: http://www.mysql.com/doc/C/o/Column_types.html Ah. One question about using CHAR(1) as BOOL, though: Will the value be stored as 0/1 or as '0'/'1'? The former would give all sorts of troubles, and the latter would require a huge number of string<->int conversions when the column is used in a WHERE. Is the performance difference between BOOL and TINYINT(1) know? Oh, and Benjamin, could you _please_ not send me two copies of the mails when you reply. I _am_ on the mysql list, you know, so there's absolutely no need to send both to the list and to my email address. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php