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: June 5, 2023