Outdated Version
You are viewing an older version of this section. View current production version.
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 |
+--------+
