OCTET_LENGTH Function [String]

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.

Parent topic: Function Support