String Functions

function ascii(string) returns int64

function byte_length $1($1) returns int64
	where $1 in (string, bytes)

function char_length(string) returns int64

function character_length(string) returns int64

function chr(int64) returns string

function code_points_to_bytes(array<int64>) returns bytes

function code_points_to_string(array<int64>) returns string

function collate(string, string) returns string

function concat(bytes, ...) returns bytes
function concat(...) returns string

function contains_substr $1($1, string) returns bool
	where $1 in (string, bigint, bool, timestamp, time, date, datetime)
function contains_substr $1(array<$1>, string) returns bool
	where $1 in (string, bigint, bool, timestamp, time, date, datetime)

function ends_with $1($1, string) returns bool
	where $1 in (string, bytes)

function format(string) returns string
function format(string, $1) returns string
function format(string, $1, $2) returns string
function format(string, $1, $2, $3) returns string
function format(string, $1, $2, $3, $4) returns string
function format(string, $1, $2, $3, $4, $5) returns string

function from_base32(string) returns bytes

function from_base64(string) returns bytes

function from_hex(string) returns bytes

function initcap(string) returns string
function initcap(string, string) returns string

function instr(string, string) returns int64
function instr(string, string, int64) returns int64
function instr(string, string, int64, int64) returns int64

function left $1($1, int64) returns $1
	where $1 in (string, bytes)

function length $1($1) returns int64
	where $1 in (string, bytes)

function lower(string) returns string

function lpad(string, int64, string) returns string
function lpad(string, int64) returns string

function ltrim(string) returns string
function ltrim(string, string) returns string

function normalize_and_casefold(string) returns string
function normalize_and_casefold(string, normalization_mode string) returns string
	where normalization_mode in (nfc, nfd, nfkc, nfkd)

function octet_length $1($1) returns int64
	where $1 in (string, bytes)

function regexp_contains $1($1, string) returns bool
	where $1 in (string, bytes)

function regexp_extract $1($1, string) returns $1
	where $1 in (string, bytes)
function regexp_extract $1($1, string, int64) returns $1
	where $1 in (string, bytes)
function regexp_extract $1($1, string, int64, int64) returns $1
	where $1 in (string, bytes)

function regexp_extract_all $1($1, string) returns array<$1>
	where $1 in (string, bytes)

function regexp_instr $1($1, $1) returns int64
	where $1 in (string, bytes)
function regexp_instr $1($1, $1, int64) returns int64
	where $1 in (string, bytes)
function regexp_instr $1($1, $1, int64, int64) returns int64
	where $1 in (string, bytes)
function regexp_instr $1($1, $1, int64, int64, int64) returns int64
	where $1 in (string, bytes)

function regexp_replace $1($1, string, string) returns $1
	where $1 in (string, bytes)

function regexp_substr $1($1, string) returns $1
	where $1 in (string, bytes)
function regexp_substr $1($1, string, int64) returns $1
	where $1 in (string, bytes)
function regexp_substr $1($1, string, int64, int64) returns $1
	where $1 in (string, bytes)

function repeat $1($1, int64) returns $1
	where $1 in (string, bytes)

function replace $1($1, string, string) returns $1
	where $1 in (string, bytes)

function reverse $1($1) returns $1
	where $1 in (string, bytes)

function right $1($1, int64) returns $1
	where $1 in (string, bytes)

function rpad(string, int64, string) returns string
function rpad(string, int64) returns string

function rtrim(string) returns string
function rtrim(string, string) returns string

function safe_convert_bytes_to_string(bytes) returns string

function soundex(string) returns string

function split $1($1) returns array<$1>
	where $1 in (string, bytes)
function split $1($1, $1) returns array<$1>
	where $1 in (string, bytes)

function starts_with(string, string) returns bool

function substr(string, int64) returns string
function substr(string, int64, int64) returns string

function substring $1($1, int64) returns $1
	where $1 in (string, bytes)
function substring $1($1, int64, int64) returns $1
	where $1 in (string, bytes)

function to_base32(bytes) returns string

function to_base64(bytes) returns string

function to_code_points $1($1) returns array<int64>
	where $1 in (string, bytes)

function to_hex(bytes) returns string

function translate $1($1, $1, $1) returns $1
	where $1 in (string, bytes)

function trim(string) returns string
function trim(string, string) returns string

function unicode(string) returns int64

function upper(string) returns string