Other Functions

Length

A generic function to calculate the length of values.

(length <expr>)

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