LENGTH
Returns the byte length of a given string, array, or binary object.
Syntax
LENGTH (expr)
Arguments
expr: any string, array, or binary object
Return Type
Integer
Examples
Example 1
SELECT CHARACTER_LENGTH('olé'), LENGTH('olé'); **** +--------------------------+----------------+ | CHARACTER_LENGTH('olé') | LENGTH('olé') | +--------------------------+----------------+ | 3 | 4 | +--------------------------+----------------+
The CHARACTER_LENGTH function returns the number of characters in the string, while the LENGTH() function returns the number of bytes in the string.
Example 2
DELIMITER // CREATE OR REPLACE FUNCTION get_length() RETURNS INT AS DECLARE a ARRAY(VARCHAR(30)); BEGIN a = ['SAM','JOE','TRUDY']; RETURN LENGTH(a); END // DELIMITER ; SELECT get_length() AS "LENGTH"; **** +--------+ | LENGTH | +--------+ | 3 | +--------+