LENGTH

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Syntax

SQL

LENGTH (expr)

Arguments

expr: any string, array, or binary object

Return Type

Integer

Examples

Example 1

SQL

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

SQL

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