Java Development Tools

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!

Bad or junk characters getting inserted in place of French accent characters in Oracle DB 11gR2

ChansMay 13 2020 — edited May 22 2020

Hi Folks,

Oracle DBCS- 11.2.0.4.0

Oracle JCSX-

When I try to insert special characters (é OR è and like), it turns as � or some junk values into Oracle DBCS sometimes.

I am wondering that this issue is encountered only on Prod environment and reproducible there. The same works fine on DEV-TEST

For ex; 'Matière principale ' becomes ==> 'Mati��re principale' and same is further getting displayed when selecting that data in APEX or our App on screen.

Please note that there is Oracle ADF App and java code is used to insert data into PaaS tables.

NLS_CHARACTERSET on DB= AL32UTF8

Source csv files are also UTF-8 encoded.

Please suggest on the same.

Thanks,

Chandan

This post has been answered by Chans on May 21 2020

Jump to Answer

Added on May 13 2020

#application-development-in-java, #jdeveloper-and-adf

5 comments

1,484 views