OCTET_LENGTH Function [String]

Returns an unsigned 64-bit value containing the byte length of the column parameter.

Syntax

OCTET_LENGTH( column-name )

Parameters

Parameter

Description

column-name

The name of a column.

Usage

The return value of a NULL argument is NULL.

The OCTET_LENGTH function supports all SAP Sybase IQ data types.

If you are licensed to use the Unstructured Data Analytics functionality, you can use this function with large object data.

See OCTET_LENGTH Function in Unstructured Data Analytics.

Standards and Compatibility

  • Sybase—Not supported by SQL Anywhere or Adaptive Server Enterprise.

Parent topic: Alphabetical List of Functions
Related reference
BIT_LENGTH Function [String]
BYTE_LENGTH Function [String]
CHAR_LENGTH Function [String]
COL_LENGTH Function [System]
DATALENGTH Function [System]
LEN Function [String]
LENGTH Function [String]
OBJECT_NAME Function [System]
STR_REPLACE Function [String]