LENGTH

The LENGTH functions return the length of a text expression.

• LENGTH counts the number of characters.
• LENGTHB uses bytes instead of characters.
• LENGTHC uses Unicode complete characters.
• LENGTH2 uses UCS2 code points.
• LENGTH4 uses UCS4 code points.

Return Value

NUMBER

Syntax

{ LENGTH | LENGTHB | LENGTHC | LENGTH2 | LENGTH4 }(char)

Arguments

char is any text expression.

Examples

LENGTH('CANDIDE') returns the value 7.

LENGTHB('CANDIDE') returns the value 7 in a single-byte character set or 14 in a double-byte character set.

Copyright © 2003, 2007, Oracle. All rights reserved.