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
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
0
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.
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.