TDV-Supported Character Function | Comments |
ASCII | See ASCII |
BITCOUNT | |
BITSTREAM_TO_BINARY | |
BIT_LENGTH | |
BTRIM | |
CHAR_LENGTH | |
CHR | See CHR |
CONCAT | See CONCAT |
DLE_DST | |
FIND | See INSTR. To use the syntax for FIND, replace <INSTR> with FIND. |
FIND_IN_SET | |
GET_JSON_OBJECT | See GET_JSON_OBJECT |
GREATEST | GREATEST treats empty strings as NULL. |
HEX_TO_BINARY | |
INET_ATON | |
INET_NTOA | |
INITCAP | |
INSTR | See INSTR |
ISUTF8 | |
JSON_TABLE | See JSON_TABLE |
LCASE | |
LEAST | LEAST treats empty strings as NULL. |
LEFT | |
LENGTH | See LENGTH |
LE_DST | |
LOWER | See LOWER |
LPAD | See LPAD |
LTRIM | |
MD5 | |
OCTET_LENGTH | |
OVERLAYB | |
PARSE_URL | |
PARTIAL_STRING_MASK | |
POSITION | See POSITION |
QUOTE_IDENT | |
QUOTE_LITERAL | |
REGEXP_EXTRACT | |
REGEXP_REPLACE | |
REPEAT | |
REPLACE | See REPLACE |
REVERSE | |
RIGHT | |
RPAD | See RPAD |
RTRIM | See RTRIM |
SPACE | See SPACE |
SOUNDEX | |
SPLIT_PART | |
STRPOS | |
SUBSTR | |
TO_CANONICAL | |
TRANSLATE | |
TRIM | See TRIM |
TRIMBOTH | |
TRIMLEADING | |
TRIMTRAILING | |
UCASE | |
UNICHR | |
UNICODE | |
UPPER | See UPPER |
V6_ATON | |
V6_NTOA | |
V6_SUBNETA | |
V6_SUBNETN | |
V6_TYPE |