HP 3000 Manuals HP 3000 Manuals
Binary Operations 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.