BINARY or VARBINARY values may be assigned to a column with
a matching data type or to a fixed or variable length character
string host variable. All rules regarding assignment to a character
string are also true for binary assignment to a character string variable.
LONG BINARY and LONG VARBINARY values cannot be converted
to any other type, and cannot participate in any expressions except
as assignments to long functions and string functions.
Character (ASCII) or hexadecimal format is used when inserting
BINARY and VARBINARY data literals into a column. Hexadecimal format
is preceded by the hexadecimal indicator 0x when inserting data
through ISQL, but not if you are inserting data through an application
program. The result of a SELECT statement on a BINARY or VARBINARY column is in
hexadecimal format.
You cannot insert BINARY literals (0's and 1's) into a CHAR
column in ISQL; however, you can insert them in an application program
using a host variable.