BIT_LENGTH

Purpose

This function returns the bit length of a string. If only ASCII characters are used, then this function is equivalent to CHARACTER_ LENGTH * 8.

Syntax

bit_length::=

Bit Length

Examples

SELECT BIT_LENGTH('aou') BIT_LENGTH;
SELECT BIT_LENGTH('äöü') BIT_LENGTH;
Result
BIT_LENGTH
24
48