Grid data cannot be displayed in jqgrid if data has escaped single quote

Returned JSON data:

{
    "page": "1",
    "total": 1,
    "records": "1",
    "rows": [
        {
            "id": "101开发者_如何学JAVA42",
            "cell": [
                "10142",
                "Hello",
                "c:\\goodies\'",
                "singlequoteissue" 
            ] 
        } 
    ]
}

String with problem (i.e. \' at the end)

"c:\\goodies\'"

jqgrid works fine without the single quote ...

Thanks in advance.

Martin

The JSON data which use receive from the server are wrong. You can validate any JSON data here. On the http://www.json.org/ is described which characters must be escaped (only " and ) and which can be escaped with the backslash. The ' character is in no from the lists. So you data should be fixed to

{
    "page": "1",
    "total": 1,
    "records": "1",
    "rows": [
        {
            "id": "10142",
            "cell": [
                "10142",
                "Hello",
                "c:\\goodies'",
                "singlequoteissue" 
            ] 
        } 
    ]
}

I recommend you don't implement manual JSON serialization on the server and use some standard function (or library). In the case you will not have such problems.

Problem found, the JSON string is not valid should be "c:\goodies'" instead