The BINARY type cannot be used in any of the following items:
Table 1-8 shows items in which specifiable/not specifiable changes in a BINARY type definition length:
Table 1-8 Items in which specifiable/not specifiable changes in a BINARY type definition length
Item | Definition length | ||
---|---|---|---|
1-255 | 256-32,000 | 32,001-2,147,483,647 | |
Sorting | Y | Y | N |
Grouping | Y | Y | N |
Set function | Y | Y | N |
Search condition | Y | Y | N |
Data insertion/updating1 | Y | Y | Y |
Duplicate elimination | Y | Y | N |
Set operations | Y | Y | N |
Concatenation operation | Y | Y | Y2 |
Scalar functions | Y | Y | Y3 |
CASE expression | Y | Y | N |
CAST specification | Y | Y | N |
When handling the BINARY type in a UAP, you can use a locator to allow you to process the SQL that handles BINARY type data without storing the data itself on a client. For a description of locators, see 1.13 Locator.