Package dev.frostlake.functions.scalar.encoding
package dev.frostlake.functions.scalar.encoding
-
ClassDescriptionBASE64_DECODE_BINARY(string) — decodes a base64 string into a BINARY value.BASE64_ENCODE(expr [, max_line_length [, alphabet]]) — the base64 encoding of the input's bytes.The optional arguments the base64 family carries beyond its input.COMPRESS(input, method) — compresses the input (a string's UTF-8 bytes, or a BINARY value's bytes) with
methodand returns the compressed bytes as BINARY, matching Snowflake's return type.The compression algorithmsCOMPRESS/DECOMPRESS_STRING/DECOMPRESS_BINARYaccept.The four compression algorithms behindCOMPRESS/DECOMPRESS_STRING/DECOMPRESS_BINARY.Themethodargument ofCOMPRESS/DECOMPRESS_STRING/DECOMPRESS_BINARY: an algorithm name with an optional compression level in parentheses, e.g.Decoded bytes read back as TEXT, which they are only allowed to be when they are valid UTF-8.DECOMPRESS_BINARY(input, method) — decompresses a BINARY input and returns the decompressed bytes as BINARY, matching Snowflake's signature.DECOMPRESS_STRING(input, method) — decompresses a BINARY input and returns the bytes as UTF-8 text.HEX_DECODE_BINARY(string) — decodes a hex string into a BINARY value.HEX_ENCODE(expr [, case]) — the hex encoding of the input's bytes, uppercase by default.TRY_BASE64_DECODE_BINARY(string) — BASE64_DECODE_BINARY that returns NULL instead of erroring.TRY_HEX_DECODE_BINARY(string) — HEX_DECODE_BINARY that returns NULL instead of erroring.