Re: Regarding Prepared Statement

Pablo Chepalich <[email protected]>
Newsgroups gmane.comp.java.sun.servlet
Message-ID <008f01c34a61$6670fdb0$5864a8c0@ntchepa>
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 
  To: [email protected] 
  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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.