on below query i am handling json. actually exactly i dont know which special character handled by json and which one is not handled by json. so when i was entering data to this particular field , i have observed that these many characters are not supported by json , so i replaced this character like below. but exactly i donot know which is supported by json and which is not supported json. so i want a generic function , by which all special characters can handle by json.
replace(replace(replace(emp_name,'\' , '\\\\' ),'''' , '\''' ),'"' , '\\"' ) ;
for above things is working fine but problem is i dont know how many specail charecters are there like this which is not handle by json. so i want to make a generic function with all special characters which can handle by JSON.