clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36247 in the last week).

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
 hidden batch(es)


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
 hidden batch(es)