Hi,
while retrieving values from
columns of datatype VARCHAR thru c programming interface we encounter the
following problem.
The retrieving values are having
length not equal to the length of the string stored in it. The value's
length is equal to the columns width and are padded with blank space. It's
just opposite to the behaviour of VARCHAR.
For example,
Consider a table
with column name NAME and datatype VARCHAR(50).
We are inserting the
value 'Example' into the table.
While retrieving
this value thru programming interface its length is 52 and the string is padded
with blank spaces.
regards,
Pavithra
|