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

Last modified: February 27, 2023

Was this article helpful?