Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I decode incoming JSON escape characters in RESTful service

Jake4321Feb 4 2021 — edited Feb 4 2021

Hi all,
currently using Application Express 20.1.0.00.13

I have this RESTful service in APEX:
l_body clob := :body_text;
...
apex_json.parse (l_body);
In my result l_body I have some encoded characters like below:
d\u00e9molition
this should translate to démolition in French.
Everything works just fine except the character conversion.
What can I use to convert or decode the unicode characters such as \u00e9 to the correct French character in the clob?
Any tips, comments, suggestions are greatly appreciated as usual.

Jake

This post has been answered by InoL on Feb 5 2021
Jump to Answer
Comments
Post Details
Added on Feb 4 2021
3 comments
1,554 views