오라클 LENGTH, LENGTHB 차이점

※ LENGTH : 문자열의 길이를 반환

※ LENGTHB : 문자열의 BYTE 를 반환

●쿼리

SELECT LENGTH(AA),

            LENGTHB(AA),

            LENGTH(BB),

            LENGTHB(BB),

            LENGTH(CC),

            LENGTHB(CC)

   FROM (SELECT '가나다라마' AA,

                         '12345' BB,

                         'ABCDE' CC

                FROM DUAL)

;

●결과

LENGTH(AA)	LENGTHB(AA)	LENGTH(BB)	LENGTHB(BB)	LENGTH(CC)	LENGTHB(CC)
5	10	5	5	5	5