The BYTE_LENGTH64 function returns
an unsigned 64-bit value containing the byte length of the large
object column or variable parameter.
Syntax
BYTE_LENGTH64( large-object-column )
Parameters
large-object-column – the name
of a LONG VARCHAR or LONG BINARY column
or variable.
Usage
The BYTE_LENGTH64 function supports
both LONG BINARY and LONG VARCHAR columns
and LONG BINARY and LONG VARCHAR variables
of any size of data. Currently, a SQL variable can hold up to 2GB
- 1 in length.