Passing invalid characters with OData queries

Sometimes we face the issue of Odata query not working for some of the data, but for some data it is working fine. When we search a bit more we can find that there is an invalid character in a value which we are passing.

These characters have to be replaced before sending.

There is a good post in Microsoft which states how to do it.

However the’ sign has not been included in this. For this character we have to pass it twice (’’) to work.

http://msdn.microsoft.com/en-us/library/aa226544%28SQL.80%29.aspx