There is a table whose primary key is of type CHAR(3) and there are some records in this table having less than three characters in primary key column. Here is the example.
Table name: REF_CCY
Primary Key: ccy_cd

There are two records.
1. "AUD"
2. "XX"

When I query the first record like this

I can get what I what.

However, when I query the second record

I can get nothing except a null pointer!

If I change the type of CHAR(3) to VARCHAR2(3), this problem would arise. Could you please tell me what I should do with the type CHAR?Many thanks![/code]

I too hate the CHAR data types

http://www.hibernate.org/90.html

edit: The oracle CHAR padding stuff is towards the bottom

CHAR fields are padded with spaces. Use a VARCHAR if you don't want padding, otherwise you have to search for "XX " (note the trailing space)