From: Vivek Khera
Date: February 6 2001 9:09pm
Subject: Re: Boolean Datatype
List-Archive: http://lists.mysql.com/mysql/64403
Message-Id: <14976.26604.551598.531955@onceler.kciLink.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "RD" == Russ Davies <russ@stripped> writes:

RD> Thanks for the suggestion, but this would still mean converting the data
RD> type from within ASP (the 'True' type) down to a char ('T') would it not?

then use

 ENUM('False','True')

instead.  Enum can have any string you want.  I personally prefer to
use the order False, True since then it also has the numeric values 0
and 1.

>> CREATE TABLE logInfo2
>> (
>> logID           INT NOT NULL UNIQUE,
>> ipAddress       VARCHAR(20) NOT NULL DEFAULT 'None',
>> boolVars        ENUM ('T', 'F') DEFAULT 'F'
>> )