MultiByte Characters and STRING Functions

View All Public Scripts Login to Run Script

Script Name MultiByte Characters and STRING Functions
Visibility Unlisted - anyone with the share link can access
Description Trying to figure out the proper usage scenarios for CHAR String Function and BYTE String Function
Contributor Oracle
Created Friday March 06, 2020

Statement 1

select LENGTH('àéíóú'),LENGTHB('àéíóú') FROM DUAL


LENGTH('ÀÉÍÓÚ') LENGTHB('ÀÉÍÓÚ')
5 10

LENGTH('ÀÉÍÓÚ')	LENGTHB('ÀÉÍÓÚ')
5	10

Statement 2

select LENGTH('àéíóú'),LENGTHB('àéíóú') FROM DUAL


LENGTH('ÀÉÍÓÚ') LENGTHB('ÀÉÍÓÚ')
5 10

LENGTH('ÀÉÍÓÚ')	LENGTHB('ÀÉÍÓÚ')
5	10

Statement 3

select SUBSTR('àéíóú',0,3),SUBSTRB('àéíóú',0,3) FROM DUAL


SUBSTR('ÀÉÍÓÚ',0,3) SUBSTRB('ÀÉÍÓÚ',0,3)
àéí à

SUBSTR('ÀÉÍÓÚ',0,3)	SUBSTRB('ÀÉÍÓÚ',0,3)
àéí	à

Statement 4

select LENGTH('àéíóú'),LENGTHB('àéíóú') FROM DUAL


LENGTH('ÀÉÍÓÚ') LENGTHB('ÀÉÍÓÚ')
5 10

LENGTH('ÀÉÍÓÚ')	LENGTHB('ÀÉÍÓÚ')
5	10

Statement 5

select SUBSTR('àéíóú',0,3),SUBSTRB('àéíóú',0,3) FROM DUAL


SUBSTR('ÀÉÍÓÚ',0,3) SUBSTRB('ÀÉÍÓÚ',0,3)
àéí à

SUBSTR('ÀÉÍÓÚ',0,3)	SUBSTRB('ÀÉÍÓÚ',0,3)
àéí	à

Statement 6

select LENGTH(SUBSTR('àéíóú',0,3)),LENGTH(SUBSTRB('àéíóú',0,3)) FROM DUAL


LENGTH(SUBSTR('ÀÉÍÓÚ',0,3)) LENGTH(SUBSTRB('ÀÉÍÓÚ',0,3))
3 2

LENGTH(SUBSTR('ÀÉÍÓÚ',0,3))	LENGTH(SUBSTRB('ÀÉÍÓÚ',0,3))
3	2

Statement 7

select LENGTH('àéíóú'),LENGTHB('àéíóú') FROM DUAL


LENGTH('ÀÉÍÓÚ') LENGTHB('ÀÉÍÓÚ')
5 10

LENGTH('ÀÉÍÓÚ')	LENGTHB('ÀÉÍÓÚ')
5	10

Statement 8

select SUBSTR('àéíóú',0,3),SUBSTRB('àéíóú',0,3) FROM DUAL


SUBSTR('ÀÉÍÓÚ',0,3) SUBSTRB('ÀÉÍÓÚ',0,3)
àéí à

SUBSTR('ÀÉÍÓÚ',0,3)	SUBSTRB('ÀÉÍÓÚ',0,3)
àéí	à

Statement 9

select LENGTH(SUBSTR('àéíóú',0,3)),LENGTH(SUBSTRB('àéíóú',0,4)) FROM DUAL


LENGTH(SUBSTR('ÀÉÍÓÚ',0,3)) LENGTH(SUBSTRB('ÀÉÍÓÚ',0,4))
3 2

LENGTH(SUBSTR('ÀÉÍÓÚ',0,3))	LENGTH(SUBSTRB('ÀÉÍÓÚ',0,4))
3	2

Statement 10

select LENGTH('àéíóú'),LENGTHB('àéíóú') FROM DUAL


LENGTH('ÀÉÍÓÚ') LENGTHB('ÀÉÍÓÚ')
5 10

LENGTH('ÀÉÍÓÚ')	LENGTHB('ÀÉÍÓÚ')
5	10

Statement 11

select SUBSTR('àéíóú',0,3),SUBSTRB('àéíóú',0,3) FROM DUAL


SUBSTR('ÀÉÍÓÚ',0,3) SUBSTRB('ÀÉÍÓÚ',0,3)
àéí à

SUBSTR('ÀÉÍÓÚ',0,3)	SUBSTRB('ÀÉÍÓÚ',0,3)
àéí	à

Statement 12

select LENGTH(SUBSTR('àéíóú',0,3)),LENGTH(SUBSTRB('àéíóú',0,3)) FROM DUAL


LENGTH(SUBSTR('ÀÉÍÓÚ',0,3)) LENGTH(SUBSTRB('ÀÉÍÓÚ',0,3))
3 2

LENGTH(SUBSTR('ÀÉÍÓÚ',0,3))	LENGTH(SUBSTRB('ÀÉÍÓÚ',0,3))
3	2

Statement 13

SELECT LENGTH('àéíóú'),LENGTHB('àéíóú') FROM DUAL


LENGTH('ÀÉÍÓÚ') LENGTHB('ÀÉÍÓÚ')
5 10

LENGTH('ÀÉÍÓÚ')	LENGTHB('ÀÉÍÓÚ')
5	10

Statement 14

SELECT SUBSTR('àéíóú',0,3),SUBSTRB('àéíóú',0,3) FROM DUAL


SUBSTR('ÀÉÍÓÚ',0,3) SUBSTRB('ÀÉÍÓÚ',0,3)
àéí à

SUBSTR('ÀÉÍÓÚ',0,3)	SUBSTRB('ÀÉÍÓÚ',0,3)
àéí	à

Statement 15

SELECT LENGTH(SUBSTR('àéíóú',0,3)),LENGTH(SUBSTRB('àéíóú',0,3)), LENGTHB(SUBSTRB('àéíóú',0,3)) FROM DUAL


LENGTH(SUBSTR('ÀÉÍÓÚ',0,3)) LENGTH(SUBSTRB('ÀÉÍÓÚ',0,3)) LENGTHB(SUBSTRB('ÀÉÍÓÚ',0,3))
3 2 3

LENGTH(SUBSTR('ÀÉÍÓÚ',0,3))	LENGTH(SUBSTRB('ÀÉÍÓÚ',0,3))	LENGTHB(SUBSTRB('ÀÉÍÓÚ',0,3))
3	2	3

Additional Information