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 |
+--------+