Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1.2

Hi all,

I'm writing an application that read and write data to a legacy Informix 7 SE database.

This database does not support VARCHAR but only CHAR. So when I load an object all String properties are filled with empty spaces up to the length of the char field in database.
This is VERY annoying.

Is there a place (in dialect or somewhere else) to instruct Hibernate to make a trim before filling object properties at load time?

Thanks

Yes, there is: build yourself a UserType that does the work for you.
Luckily ,since this is a very common problem, someone has already done this. Just have a look at this thread.