I have a db column defined as char(1) that I want to bind to a checkbox.  When retrieving a row if the value is 'Y', the checkbox should be checked.  For any other value the checkbox should be unchecked.  When inserting/updating the row if the checkbox is checked the value should be 'Y'.  For unchecked, the value can be 'N'.  If this isn't possible, what datatype should be used.  Thanks!!