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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...