REM Script: 18c character encoding validation Script: 18c character encoding validation
REM New routines in UTL_I18N allow for validation of characters within a particular characterset New routines in UTL_I18N allow for validation of characters within a particular characterset
select * from database_properties
where property_name in ('NLS_NCHAR_CHARACTERSET','NLS_CHARACTERSET') | PROPERTY_NAME | PROPERTY_VALUE | DESCRIPTION | NLS_NCHAR_CHARACTERSET | AL16UTF16 | NCHAR Character set | NLS_CHARACTERSET | AL32UTF8 | Character set |
|---|
drop table charset_testORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create table charset_test(col1 varchar2(20), col2 nvarchar2(20)) Table created.
insert into charset_test
values(
unistr('foo\D800bar'),
unistr('foo\D800bar')
) 1 row(s) inserted.
commitStatement processed.
select * from charset_test | COL1 | COL2 | foo�bar | foo�bar |
|---|
select
utl_i18n.validate_character_encoding(col1) invalid_offset_column1,
utl_i18n.validate_character_encoding(col2) invalid_offset_column2
from charset_test | INVALID_OFFSET_COLUMN1 | INVALID_OFFSET_COLUMN2 | 0 | 7 |
|---|