Sorry for the confusion but I have successfuly got it working with a VARCHAR2() 
column. First of all I set the table up like this:

CREATE TABLE CURRENCY
  | (
  |   CURRENCY                     VARCHAR2(8 CHAR)     NOT NULL,
  |   ...
  | )

This yielded the same sorry result of padding chars.

Finally, using the following:

CREATE TABLE CURRENCY
  | (
  |   CURRENCY                     VARCHAR2(8)     NOT NULL,
  |   ...
  | )

prevented the padding happening and I got consistent behaviour. I am not sure 
whether Hibernate can or should take this into account. Perhaps a warning about 
the use of CHAR based column types?

Tom.


View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3972904#3972904

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3972904
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to