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 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' >> )