Re: Regarding Prepared Statement

[James Hicks]

Title: Message

Verify that the field type is varchar and not char.  If it is varchar, try changing db drivers.  The driver could be appending the empty spaces because it thinks the field is of type char.   James -----Original Message----- From: Inderjit Singh [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 7:49 AM To: [EMAIL PROTECTED] Subject: Re: Regarding Prepared Statement Try to trim the NAME before comparisons. See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316626 for more details.   Hope this helps Inderjit   -----Original Message----- From: K R Viju [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 2:47 PM To: [EMAIL PROTECTED] 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