Prepared Statements pad white spaces for varchar values?
0 posts in topic
Flat View  Flat View

Posted By:   swati_rohra
Posted On:   Saturday, May 25, 2002 12:35 AM

I am using JDBC-ODBC driver to connect to a SQL database. i use PreparedStatement to insert data. I used the setString() method to set the values. After inserting the values that if the actual length of the string to be inserted is less than the value specified in the database, white spaces are appended to the string. this is giving me problems as the data is being retrieved by another application which expects the trimmed data. Is there any way i can change this behaviour?

About | Sitemap | Contact