Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

LENGTH

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

LENGTH

On this page

Syntax

Arguments

Return Type

Examples

Example 1

Example 2

Was this article helpful?

On this page

Was this article helpful?