By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT DUMP(CHR(14849958), 1016) AS "UTF8",
DUMP(CHR(9702 USING NCHAR_CS), 1016) AS "UTF16BE",
DUMP(CONVERT(CHR(9702 USING NCHAR_CS), 'AL16UTF16LE' ), 1016) AS "UTF16LE"
FROM DUAL;
| UTF8 | UTF16BE | UTF16LE |
|---|---|---|
| Typ=1 Len=3 CharacterSet=AL32UTF8: e2,97,a6 | Typ=1 Len=2 CharacterSet=AL16UTF16: 25,e6 | Typ=1 Len=2 CharacterSet=AL16UTF16: e6,25 |
SELECT DUMP('a' || CHR(14849958), 1016) AS "UTF8",
DUMP('a' || CHR(9702 USING NCHAR_CS), 1016) AS "UTF16BE",
DUMP(CONVERT('a' || CHR(9702 USING NCHAR_CS), 'AL16UTF16LE' ), 1016) AS "UTF16LE"
FROM DUAL;
| UTF8 | UTF16BE | UTF16LE |
|---|---|---|
| Typ=1 Len=4 CharacterSet=AL32UTF8: 61,e2,97,a6 | Typ=1 Len=4 CharacterSet=AL16UTF16: 0,61,25,e6 | Typ=1 Len=4 CharacterSet=AL16UTF16: 61,0,e6,25 |