OCTET_LENGTH

version 11

OCTET_LENGTH (arithmetic_expression)

The OCTET_LENGTH function returns the number of bytes of the arithmetic_expression, including any trailing whitespace.

This example returns the number of octets for a column comprised of binary data:

   SELECT OCTET_LENGTH (MyBinary_col) 
    FROM MyTable 
    WHERE MyBinary_col = '93FB';
       ` returns 2

BIT_LENGTH.