You must to specified the column as varchar2, cos when its varchar the string is completed with blanks to reach the size column defined.
regards, Pablo
 
----- Original Message -----
From: K R Viju
Sent: Friday, July 11, 2003 6:16 AM
Subject: Regarding Prepared Statement

List,
 
We have a table called CUST.
CUST has one column called NAME Varchar (25)
When i insert a row using PREPARED STATEMENT, thou i insert a string of length 10, it adds space and inserts 25 length.
 
what cud be the problm?
am using MS SQL 2000.
 
Thanks
Viju

Reply via email to