You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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