This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored procedure call removes spaces in text

 
Trader Joey
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I have written a stored procedure to store some data into a table. The stored procedure contains an insert statement that inserts a new record. There are a number of fields that are of type varchar. When I insert a new record using this stored procedure, all the spaces in the varchar fields are missing. so "how are you today" is stored as "howareyoutoday". Can anyone help me to solve this problem?
I am using SQL Server as my database, the Microsoft JDBC connector for SQL.
This is interesting too.
When I call the stored procedure using the SQL server query analyser, the result is fine. The spaces show properly. Its only when I run the stored procedure through a Java client that the error occurs.
Thanks
Nikhil
[ May 27, 2003: Message edited by: Nikhil Nikhil ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic