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