(length <expr>)
Other Functions
Length
A generic function to calculate the length of values.
LENGTH(<expr>)
Where <expr>
is one of the following:
-
A string - returns the number of utf8 characters in the string
-
Acts as an alias for the
CHAR_LENGTH
function - see in String Functions
-
-
A varbinary - returns the number of bytes in the varbinary
-
Acts as an alias for
OCTET_LENGTH
function - see in String Functions
-
-
A list - returns the number of elements in the list
-
A set - returns the number of elements in the set
-
A struct - returns the number of non-absent fields in the struct