Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

STRING_BYTES

Syntax

SQL

STRING_BYTES(str)

Arguments

str: any string

Return Type

An PSQL array.

Remarks

If str is in ASCII format, then the length of the PSQL array is same as the length of the input string.
For UTF-8 characters that require multiple bytes, the PSQL array will contain the integer value of each byte.

Example

The following example demonstrates the usage of the STRING_BYTES() function through a stored procedure.

SQL

USE trades;

DELIMITER //

CREATE OR REPLACE PROCEDURE Procedure1(s VARCHAR(80)) AS
DECLARE
  a ARRAY(TINYINT UNSIGNED NOT NULL);
  l INT;
  BEGIN
  a = STRING_BYTES(s);
  l = LENGTH(a);
  ECHO SELECT l as l;
  FOR i IN a LOOP
    ECHO SELECT i AS i;
  END LOOP;
END //
DELIMITER ;

SQL

CALL Procedure1('a€bc');

+------+
| l    |
+------+
| 6    |
+------+
1 row in set (0.00 sec)

+----+
| i  |
+----+
| 97 |
+----+
1 row in set (0.00 sec)

+-----+
| i   |
+-----+
| 226 |
+-----+
1 row in set (0.00 sec)

+-----+
| i   |
+-----+
| 130 |
+-----+
1 row in set (0.00 sec)

+-----+
| i   |
+-----+
| 172 |
+-----+
1 row in set (0.00 sec)

+----+
| i  |
+----+
| 98 |
+----+
1 row in set (0.00 sec)

+----+
| i  |
+----+
| 99 |
+----+
1 row in set (0.00 sec)

In the output, the values 97, 98, and 99 are one-byte decimal integer codes for a, b, and c, respectively. The values 226, 130, and 172 represent the three bytes code for the symbol €.

Last modified: July 14, 2026