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.

2 total posts (Page 1 of 1)  
| 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.

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums