Hi,
we have a database in wich boolean values are stored as text (varchar or char). So, if we want to store a true value, we store something like 'Y', and for false, something like 'N', so when we need these data, we can make a simple conversion inside our own code.
But now we are using Hibernate (and loving it!). So here is my question: how can I map these values stored as text to boolean values?
Is it possible? How can we do it?

Hibernate version: 3.2 RC

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: MySQL 5.0.22

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I use something like this with the same requirement

type="yes_no" for SQL CHAR(1) type where the field contains {'Y','N'}
type="true_false" for SQL CHAR(1) type where the field contains {'T','F'}

Can you do this if the column is of type enum('TRUE', 'FALSE')? We have some existing tables that do this. We also have a bunch that use and integer 0 for false and integer 1 for true. I am trying to avoid writing a custom UserType class, and would like to return a boolean or a Boolean.