CHAR_LENGTH/CHARACTER_LENGTH/LENGTHB/LENGTH Functions

Description

CHAR_LENGTH, LENGTHB, and LENGTH are used interchangeably.

They return the length of a character string (byte) as an integer. The return value may be different depending on the character set (e.g., EUC-KR: 2 bites).

For details about the character sets supported by CUBRID, see Definition and Characteristics.

Syntax

CHAR_LENGTH( string )

CHARACTER_LENGTH( string )

LENGTHB( string )

LENGTH( string )

 

string :

• character string

NULL

Remark
Example

--character set is euc-kr for Korean characters

SELECT LENGTH('');

char length('')

==================

                 0

 

SELECT LENGTH('CUBRID');

char length('CUBRID')

==================

                 6

 

SELECT LENGTH('큐브리드');

char length('큐브리드')

==================

                 8

 

CREATE TABLE length_tbl (char_1 CHAR, char_2 CHAR(5), varchar_1 VARCHAR, varchar_2 VARCHAR);

INSERT INTO length_tbl VALUES('', '', '', ''); --Length of empty string

INSERT INTO length_tbl VALUES('a', 'a', 'a', 'a'); --English character

INSERT INTO length_tbl VALUES(NULL, '큐', '큐', '큐'); --Korean character and NULL

INSERT INTO length_tbl VALUES(' ', ' 큐', ' 큐', ' 큐'); --Korean character and space

 

SELECT LENGTH(char_1), LENGTH(char_2), LENGTH(varchar_1), LENGTH(varchar_2) FROM length_tbl;

 

char_length(char_1) char_length(char_2) char_length(varchar_1) char_length(varchar_2)

================================================================================

 

1                     5                        0             0

1                     5                        1             1

NULL                  5                        2             2

1                     5                        3             3