|
|
|
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.
|
Complete PDF