BINARY

Overview

Casts strings to binary values.

See also: SQL Operators in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

SELECT 'foo' = BINARY 'FOO';
+----------------------+
| 'foo' = BINARY 'FOO' |
+----------------------+
|                    0 |
+----------------------+
SELECT 'foo' = CAST(BINARY 'FOO' AS CHAR);
+------------------------------------+
| 'foo' = CAST(BINARY 'FOO' AS CHAR) |
+------------------------------------+
|                                  1 |
+------------------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES