Re: Boolean values in MySQL
| From: | JJeffman | Date: | Mon, 15 Jan 2001 00:53:34 +0000 |
| Subject: | Re: Boolean values in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5858@lists.php.net to get a copy of this message | ||
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 <cal@calevans.com>
Para: <php-db@lists.php.net>
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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net