The OCTET_LENGTH function returns
an unsigned 64-bit value containing the byte length of the large
object column or variable parameter.
Syntax
OCTET_LENGTH( column-name )
Parameters
large-object-column – the name
of a LONG VARCHAR or LONG BINARY column
or variable.
Usage
- If the argument is NULL, OCTET_LENGTH returns NULL.
- OCTET_LENGTH supports all SAP Sybase IQ data types and LONG
VARCHAR and LONG BINARY
variables of any size of data. Currently, a SQL variable can hold up to 2GB
- 1 in length.