Lists & arrays Scalar

character_length()

Returns the bit-length of the bit argument.

Arguments & returns

3 overloads

Scalar

Overload link	`bit`	Returns
#01	`BIT`	`BIGINT`

Scalar

Returns the length of the list.

Overload link	`list`	Returns
#02	`ANY[]`	`BIGINT`

Scalar

Number of characters in string.

Overload link	`string`	Returns
#03	`VARCHAR`	`BIGINT`

SELECT character_length(42::TINYINT::BIT);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT character_length([1,2,3]);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT character_length('Hello🦆');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.