You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

BINARY

Casts the input to a binary datatype. There is usually no visible effect on the printed value; what changes is the rules for comparison and sorting.

Syntax

BINARY( input )

Return Type

A binary object.

Examples

memsql> select 'ohai' = 'OHAI', binary('ohai') = 'OHAI';
+-----------------+-------------------------+
| 'ohai' = 'OHAI' | binary('ohai') = 'OHAI' |
+-----------------+-------------------------+
|               1 |                       0 |
+-----------------+-------------------------+