This is a migrated thread and some comments may be shown as answers.

Leading space problem

1 Answer 46 Views
Editor
This is a migrated thread and some comments may be shown as answers.
Rowen
Top achievements
Rank 1
Rowen asked on 21 Aug 2008, 03:23 AM
Hi,

I found some strange behaviour when working with content with a leading space in the text. I use the get_html javascript method in order to save the content down to sql server through an ajax call. This is working fine. I package up the content in an xml packet and parse this out in sql server.

However, when I have a leading space in the content, this space (and this space only) is encoded differently and breaks my stored proc. I have managed to fix this by using an NVARCHAR parameter rather than a VARCHAR parameter, which is the correct practice for passing in xml to a stored proc, but thought I should let you know about the strange behaviour.

Regards,

Rowen

1 Answer, 1 is accepted

Sort by
0
Rumen
Telerik team
answered on 21 Aug 2008, 01:08 PM
Hi Rowen,

Thank you for sharing your solution, it could be useful for the users that experience this problem. I am glad that you fixed this problem and I updated your points for the provided solution.

Sincerely yours,
Rumen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
Editor
Asked by
Rowen
Top achievements
Rank 1
Answers by
Rumen
Telerik team
Share this question
or