Re: Boolean Datatype

[Vivek Khera]

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