I'm using tinyint. If you are afraid of data volume I think char(1) with
"T/F" values uses less disk space but requires more sophisticated code to
deal with.

Jayme.

http://www.conex.com.br/jjeffman



-----Mensagem Original-----
De: Cal Evans <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: sábado, 13 de janeiro de 2001 22:35
Assunto: [PHP-DB] Boolean values in MySQL


> Question to those of you using MySQL.
>
> What is the accepted practice for storing boolean values? Do you use a
> tinyInt 0=false 1=true or an enum("T","F")? Or is there another way I'm
not
> seeing?
>
> Cal
> *
> * Professional Nerd Herder
> * http://www.calevans.com
> *
>
>


----------------------------------------------------------------------------
----


> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to