Hibernate version: 3.1.3

Name and version of the database you are using: Oracle 10g

I need to represent a boolean value in the database as 'Y' or 'N'. I'd rather not, but I have no control over DB design.... here's an example column:



Does hibernate have [some] built-in support for this sort of thing, or do I need to write my own custom type?

This should solve your problem :

create a property like this in your spring file :

<prop key="hibernate.query.substitutions">true 'T', false 'F'</prop>


If still not satisfied see this :
hibernate-3.1\doc\reference\en\html_single\index.html

(3.4.5) Query Language Substitution


------
Prashant.Jain

Dont forget to rate !

silvaran, see the hibernate docs, 5.2.2. Basic value types.
I think that the "yes_no" and "true_false" types are your choice. Also you can create your oun custom type for this issue.

Someone implemented a UserType to do this here: http://www.hibernate.org/189.html

Wow, credits all around, thanks folks! :)