Search notes:

UTL_I18N.STRING_TO_RAW

utl_i18n.string_to_raw converts a varchar2 or nvarchar2 to a binary representation in a given character set and returns the corresponding value as a raw.

column default_ format a14
column latin_1  format a11
column utf_8    format a14

select
   regexp_replace(utl_i18n.string_to_raw('René'                ), '(..)', '\1 ')  default_,
   regexp_replace(utl_i18n.string_to_raw('René', 'we8iso8859p1'), '(..)', '\1 ')  latin_1,
   regexp_replace(utl_i18n.string_to_raw('René', 'utf8'        ), '(..)', '\1 ')  utf_8
from
   dual;
--
-- DEFAULT_         LATIN_1       UTF_8         
-- --------------   -----------   --------------
-- 52 65 6E C3 A9   52 65 6E E9   52 65 6E C3 A9

UTL_I18N.STRING_TO_RAW

See also