Web Development

General discussion

Locked

Data types

By sirishakoka ·
In my program I'm using name as char(60) and country as varchar2(60)
when i trim the values of country varchar2(60) its displaying only one character and when trim the value of name char(60) it prints the whole data.
fro eg: when i trim the values of country detroit it displays only t for name james after timr it displays as james.
can someone explain me why is it so? am'i doing something wrong.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Data types

by sgt_shultz In reply to Data types

post your formulae?

Collapse -

Data types

by sirishakoka In reply to Data types

eg:
name char(60)
fathers_name varchar2(60)
name='James'
fathers_name='williams'
if((type == CHAR) || (type == VARCHAR))
stmt.setString(index,value.trim());
when i use above condition for name and fathers_name
it prints only james for nameand only one letter 'i' for fathers_name.

Related Discussions

Related Forums