My database language type NLS_CHARACTERSET is US7ASCII. I'm created REST Service in Apex and to insert the data into my custom table without issue. Now the problem is my posted JSON data with Chinese character and is not readable and it shown "?".
I did changed my table structure to nvarchar2 and using SQL developer to run the following syntax and it success, I'm able to read the Chinese character.
insert into test_table (f1) values (N'测');
Now my question is whether in Apex I can use same method ? I had tried in Apex using following syntax, but it does not worked. Appreciate for help.
insert into test_table (f1) values (N':item_desc);
insert into test_table (f1) values (N'':item_desc);
Thanks in advance.