Web Development

Ask something
Discussion Locked

Data types

0 helpful
2 replies

by sirishakoka 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by sirishakoka

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.

This discussion is closed to new replies.