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 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 Unstructured Data Analytics in Sybase IQ > Function Support.

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]