Categories:: Semi-structured and structured data functions (Type Predicates)

IS_BINARY¶

Returns TRUE if its VARIANT argument contains a binary string value.

Syntax¶

IS_BINARY( <variant_expr> )

Returns a BOOLEAN value or NULL.

Returns TRUE if the VARIANT value contains a BINARY value. Otherwise, returns FALSE.
If the input is NULL, returns NULL without reporting an error.

Return all of the BINARY values in a VARIANT column.

Note

The output format for BINARY values is set using the BINARY_OUTPUT_FORMAT parameter. The default setting is HEX.

Create and load a table with a BINARY value in a VARIANT column:

CREATE OR REPLACE TABLE varbin (v VARIANT);

INSERT INTO varbin SELECT TO_VARIANT(TO_BINARY('snow', 'utf-8'));

Show the BINARY values in the data by using the IS_BINARY function in a WHERE clause:

SELECT v AS hex_encoded_binary_value
  FROM varbin
  WHERE IS_BINARY(v);

+--------------------------+
| HEX_ENCODED_BINARY_VALUE |
|--------------------------|
| "736E6F77"               |
+--------------------------+