Identify how Checkbox Fields are Represented in ODBC Table View Queries

Checkbox fields are distinguished in the ODBC Query results by the following:

Type: Varchar2
Precision: 3
Length: 3
Nullable: Yes

The results will contain a Yes, No. Since it is of a nullable type, a special value of null is also acceptable amongst the common values.



Pick the Inactive checkbox on an Employee record

The table view for the field shows the Column Name, Type, Precision, Length, Nullable

Checkbox:

if Checked = Yes
if Unchecked = No