Hi,
MySQL doesn't support this kind of fields - if you want to have a field that
have only two values like 0/1 you should use char(1) or enum(0,1).

Dobromir Velev


-----Original Message-----
From: Bartek Pawlik <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>;
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, October 02, 2001 12:57 PM
Subject: Odp: [PHP-DB] Yes or No


>Use boolean field, it takes only values Yes/No, 0/1, True/False.
>
>Bartek Pawlik
>Poland
>
>
>----- Original Message -----
>From: Jordan Elver <[EMAIL PROTECTED]>
>To: MySQL Mailing List <[EMAIL PROTECTED]>; PHP DB Mailing List
><[EMAIL PROTECTED]>
>Sent: Tuesday, October 02, 2001 11:23 AM
>Subject: [PHP-DB] Yes or No
>
>
>> Hi,
>> If I wanted to define a table to have a cloumn which is either yes or no
>for
>> example. Would it be better to use a single char (0 or 1), or can I use
an
>> enum (I find them more friendly ;)).
>>
>> Could you offer some advice?
>>
>> Thanks,
>>
>> Jord
>> --
>> Jordan Elver
>> Web Developer
>> The InternetOne UK Ltd
>>
>> --
>> 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]
>>
>
>
>
>--
>
>Zagraj z finalistkami
>Miss Polonia [ http://miss.onet.pl/start.html ]
>
>
>--
>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