At 17:25 06.09.01, you wrote:
>Or ENUM:
>ALTER TABLE myTable CHANGE COLUM myColumn ENUM( 'T', 'F' );
>
>Of course if you are using this to drive a web page Mike's solution is better.
> Or you would want to enum( 1, 0 ) or enum( '1', '' );
yes, but do *not* use enum('t','f') because with some fonts they are not
easily distinguised. it is not very funny to find the one "f" within a
column of 30 "t"s. :-)
and think about clever defaults here.
henning
---------------------------------------------------------------------
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
