Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

BIT_LENGTH function [Bit array]

Returns the number of bits stored in the array.

BIT_LENGTH( bit-expression )

bit-expression    The bit expression for which the length is to be determined.

• BIT_LENGTH function [Bit array]
• CHAR_LENGTH function [String]

SQL/2003    Vendor extension.

The following statement returns the value 8:

SELECT BIT_LENGTH( '01101011' );