Urgently seek for advice for below issues, thanks you in advance.
After we migrated oracle database server from 10g to 12c, with charset changed from BIG5 to UTF-8,
the result obtained from oracle functions through SQLCA are different between PB app and Web app,
ls_call_ref_no = sqlca.f_gen_doc_no('CIC', 'CIC', ls_user_id)
Result in PB App: CIC20190400001 << 14 characters
Result in Web App: CIC2019 << 7 characters
So I make a guess, it should be related to single byte / double byte issue, meanwhile the encoding is incorrect when Chinese character is updated by Web App, meanwhile it is correct by PB App.
I have gone through the database setting for Web App, but I could not find something related.
Please advise for the above finding. Thanks.