Hi all,

I'm trying to find out wether it is possible to map to fixed length SQL CHAR columns. It appears that the hibernate type "string" always maps to a VARCHAR.
As far as I understand using only fixed length fields on a table is going to make query faster as it makes it much easier to compute the offset of a record. Am I mistaken here ?

Thanks

Hibernate version:
3.0rc1
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 4.1
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Thanks everybody, I figured it out. I can use the column tag's sql-type attribute to do this:

<column
name="myCol"
sql-type="char(40)"
/>