OCTET_LENGTH

Takes one argument as an input and returns the string length in octets for all string types.

Behavior Type

Immutable

Syntax

OCTET_LENGTH ( expression )

Parameters

expression

(CHAR or VARCHAR or BINARY or VARBINARY) is the string to measure.

Notes

Examples

Expression

Result

SELECT OCTET_LENGTH(CHAR(10) '1234  ');
4
SELECT OCTET_LENGTH(CHAR(10) '1234');
4
SELECT OCTET_LENGTH(CHAR(10) '  1234');
6
SELECT OCTET_LENGTH(VARCHAR(10) '1234  ');
6
SELECT OCTET_LENGTH(VARCHAR(10) '1234 ');
5
SELECT OCTET_LENGTH(VARCHAR(10) '1234');
4
SELECT OCTET_LENGTH(VARCHAR(10) '  1234');
7
SELECT OCTET_LENGTH('abc'::VARBINARY);
3
SELECT OCTET_LENGTH(VARBINARY 'abc');
3
SELECT OCTET_LENGTH(VARBINARY 'abc  ');
5
SELECT OCTET_LENGTH(BINARY(6) 'abc');
6
SELECT OCTET_LENGTH(VARBINARY '');
0
SELECT OCTET_LENGTH(''::BINARY);
1
SELECT OCTET_LENGTH(null::VARBINARY);

                            
SELECT OCTET_LENGTH(null::BINARY);