we are trying to use a jdbc connection for Oracle DBMS.
The problem is that when we try to do a “Select” statement using a data type “nChar” into the where column we must pad the input vale before passing it into the input value of the adapter. This happens mainly because the nchars in oracle have a fixed length.
I would like to know if there is a way to bypass this behavior so that i can retrieve, for example, record like this:
supposing that name is an nchar( 8 ) column
select surname from people where name='joe'
instead of be obliged to do
select surname from people where name='joe '
(or padRight the name value till 8 chars before using it)
This is my environment:
Can someone help me?