Update failing because of special charecters


#1

I am trying update exiting document with update query.
I want to update the String highlighted below which is having some special characters.
But I am getting error hilighted in below. ANybody can help me on this.

[
{
“code”: 3000,
“msg”: “syntax error: invalid quoted string - at ‘Invalid Name Allowable Characters are alphanumeric plus common special characters ? , \ ! | : . - _ @ * %!~(MISSING) # ^ %!?(MISSING) £ ¢ ¤ ¬*", "query_from_user": "update BUCKETNAME set EXPECTEDRESULT.error.error_details.message = 'Invalid Name Allowable Characters are alphanumeric plus common special characters [ ] ? , \\ ! | : . - _ @ * % ~ # ^ % ? £ ¢ ¤ ¬’\nwhere tcid = ‘TESTID002’ and EXPECTEDRESULT.error.error_details.code = ‘ERRORCODE005’”
}
]


#2

Following seems to work. Check proper quotes and find which character has been issue.

update default 
set error = 'Invalid Name Allowable Characters are alphanumeric plus common special characters [ ] ? , \\ ! | : . - _ @ * % ~ # ^ % ? £ ¢ ¤ ¬';