General Manipulation

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

Full-Text Search

Case Conversion

Regular Expression Matching

Alias for RLIKE.

Alias for REGEXP_SUBSTR_ALL.

Alias for RLIKE.

Other Matching/Comparison

✔

✔

Alias for POSITION. Provides partial support for collation. For details, see the documentation of the POSITION function.

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

Case-insensitive alternative for LIKE.

Case-insensitive alternative for LIKE ANY.

✔

✔

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

✔

✔

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

✔

✔

Compression/Decompression

✔

✔

✔

Encoding/Decoding

✔

✔

Error-handling version of BASE64_DECODE_BINARY.

Error-handling version of BASE64_DECODE_STRING.

Error-handling version of HEX_DECODE_BINARY.

Error-handling version of HEX_DECODE_STRING.

Cryptographic/Checksum

Intended primarily for checksum operations. Not recommended for cryptography.

Intended primarily for checksum operations. Not recommended for cryptography.

Intended primarily for checksum operations. Not recommended for cryptography.

Intended primarily for checksum operations. Not recommended for cryptography.

Hash (Non-cryptographic)

✔

Allows data types other than string and binary. Not intended for cryptography.

✔

Allows data types other than string and binary. Not intended for cryptography.

Collation

AI Functions