adapter - webmethods oracle issue with nchar -

when try "select" statement using data type "nchar" column must pad input value before passing input value of adapter. happens because nchars in oracle have fixed length. know if there way bypass behavior can retrieve, example, record this: supposing name nchar(8) column

select surname people name='joe'     

instead of obliged do

select surname people name='joe     ' 

this environment: webmethods 9.7 adapter 9.0 ojdbc7

either change column data type nvarchar(8) or use like operator as

where name 'joe%' 

(or) use trim() function like

where trim(name) = 'joe' 

(or) use rpad() function like

where name = rpad('joe',8, ' ');