How to represent Char(n) in Hibernate without space problem

HibernateSubbu · **Joined:** Mon Sep 25, 2006 7:42 am **Posts:** 7

Hibernate version: 3.0

Name and version of the database :Oracle 10g

General Question ::

How can i trim String data for using it with Char in Oracle
eg: I have a table with Char(5) and data less than 5 chars then i am getting spaces in place of rest of the characters., which i dont want.,
How can overcome this problem without changing the Database?

rajasaur · **Joined:** Tue Aug 23, 2005 8:52 am **Posts:** 181

you might need to define it as VARCHAR2(5)

Check a similar thread.
http://forum.hibernate.org/viewtopic.ph ... light=char

CWitherow · **Posted:** Mon Sep 25, 2006 12:05 pm

You need to build and use a custom UserType in your Hibernate mapping. That way, the db stays as char(n), the POJO uses String and the custom UserType does the conversion between the two. See http://www.hibernate.org/388.html in the wiki for an example.

Curtis ...

HibernateSubbu · **Joined:** Mon Sep 25, 2006 7:42 am **Posts:** 7

CWitherow wrote:

You need to build and use a custom UserType in your Hibernate mapping. That way, the db stays as char(n), the POJO uses String and the custom UserType does the conversion between the two. See http://www.hibernate.org/388.html in the wiki for an example.

Curtis ...

Thanks Curtis...I will see if this works....