On this page

    Categories: Binary

    BIT_LENGTH

    Gets length of bits of the input expression

    Syntax

    BIT_LENGTH(expression BINARY, VARCHAR) → BINARY

    • expression: A binary or varchar expression

    Examples

    BIT_LENGTH example
    SELECT BIT_LENGTH(1010)
    -- 32
    
    BIT_LENGTH example
    SELECT BIT_LENGTH('DREMIO')
    -- 48
    
    BIT_LENGTH example
    SELECT BIT_LENGTH('abc')
    -- 24
    
    BIT_LENGTH example
    SELECT BIT_LENGTH(NULL)
    -- None