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:
Thanks for your answer. Of course if I pad the value it works but as I’ve said I do’n’t want to. If I were going to use padRight I will have to use it in too many pieces of my code. So my question is if there’s a property to set into the connection or if I have to use a different driver or something like that.
I understand your point that the current solution is not feasible and a best approach. Let me do some analysis to check if JDBC adapter supports this or we can also do this via FF for padding spaces at right.