Oracle Database Discussions

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!

problem identifieng characterset

Frank LehmannNov 6 2022 — edited Nov 6 2022

Hi helpers,
i have this raw data and want to convert to right form.
select dump(utl_i18n.raw_to_char( '262077C3', null )), utl_i18n.raw_to_char( '262077C3', null ) from dual
Actual values are:
Typ=1 Len=4: 38,32,119,195 & w
select dump(utl_i18n.raw_to_char( '262077C3', 'AL32UTF8')), utl_i18n.raw_to_char( '262077C3', 'AL32UTF8' ) from dual
ORA-01890: NLS-Fehler entdeckt
ORA-06512: in "SYS.UTL_I18N", Zeile 72
ORA-06512: in "SYS.UTL_I18N", Zeile 353
ORA-06512: in Zeile 1
01890. 00000 - "NLS error detected"
*Cause: An NLS error was detected.
*Action: Look for additional error messages and take appropriate action.
If there are no additional errors, call Oracle Worldwide Support.

Correct output should be:
& wä

The data is getting with an api request which should send utf-8 !
any hints ?

This post has been answered by cormaco on Nov 7 2022

Jump to Answer

Added on Nov 6 2022

#general-database-discussions

17 comments

517 views

1 mention