To check the character set in use by your database, execute the following query in SQL*Plus:
SQL> SELECT parameter, value FROM nls_database_parameters
WHERE parameter = 'NLS_CHARACTERSET';
PARAMETER VALUE
------------------ ---------------------
NLS_CHARACTERSET UTF8
SQL>.
Unicode support is dependent on the Unicode features available through the Oracle Call Interface (OCI). OCI 8.1.5 supports inputting Unicode data into a database and retrieving Unicode data from a database.
The Following Oracle Data types can be using for storing Unicode data:
We commonly see this symptom when the design has a service endpoint that manually serializes a JSON string rather than simply returning a type. Essentially the double serialization. Once to create JSON in code and again when returning a string form an
Action.
None
0 Points
3 Posts
Oracel db Store arabic data with question mark
Feb 27, 2020 10:40 AM|rajaprasad07|LINK
Hello All,
I am trying to insert the data from postman to oracle with the help of webapi.
Post data
{ "apiValue":"123 ا ب ح" }After debugging (Values received in the back-end)
Data stored in the database
The problem here, "?" comas added extra in the database.
Finally the data need to be stored in the database as specified below
Guide me to sort out the issue.
Note : database support arabic.
None
0 Points
3 Posts
Re: Oracel db Store arabic data with question mark
Feb 27, 2020 11:52 AM|rajaprasad07|LINK
Database s
Database support the the arabic.
All-Star
53001 Points
23595 Posts
Re: Oracel db Store arabic data with question mark
Feb 27, 2020 12:02 PM|mgebhard|LINK
We commonly see this symptom when the design has a service endpoint that manually serializes a JSON string rather than simply returning a type. Essentially the double serialization. Once to create JSON in code and again when returning a string form an Action.