From: Date: March 23 1999 12:10am
Subject: Binary type? True/False, Yes/No, On/Off
List-Archive: http://lists.mysql.com/mysql/809
Message-Id: <36F6CDFE.2D4A2B20@TheMatrix.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Is there a preferred way to make a field in a SQL database that only has two
options, such as Yes/no, On/Off, True/False?

I have a field that would equate to a checkbox on a web page. Either the person
wants to be contacted or they don't.
What is the best way to create that field in mySQL? Using a TINYINT? CHAR? ENUM?

It seems there should be a field/data type for this kind of "flag" scenario.

Daevid Vincent.
What is http://TheMatrix.com