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.
STRING_
On this page
The STRING_ function converts a string to a SingleStore Helios Procedural SQL (PSQL) array of integers (TINYINT UNSIGNED) where each array element is the integer byte value of a character, or a byte within a multiple byte character, in the input string.
Multiple byte characters in the input string generate more than one entry in the output array.
Syntax
STRING_BYTES(str)
Arguments
-
str: any string
Return Type
An PSQL array.
Remarks
-
If
stris 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_ function through a stored procedure.
USE trades;DELIMITER //CREATE OR REPLACE PROCEDURE Procedure1(s VARCHAR(80)) ASDECLAREa ARRAY(TINYINT UNSIGNED NOT NULL);l INT;BEGINa = STRING_BYTES(s);l = LENGTH(a);ECHO SELECT l as l;FOR i IN a LOOPECHO SELECT i AS i;END LOOP;END //DELIMITER ;
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.€.
Last modified: