I was told to use a char(1) in a MySQL database since it doesn't have a boolean type. I retrieve a char(1) field but I can't seem to cast it to be a boolean. How is this done? Thanks.