v.21.11New Features

Allow Binary Literals in Query Syntax

Official CH changelog text
Allow to write number in query as binary literal. Example SELECT 0b001;. #29304 (Maksim Kita).
ClickHouse now supports binary literals in queries, allowing numbers to be written with a 0b prefix, for example, SELECT 0b001;.

Why it matters

This feature enables users to write numeric literals in binary format directly within SQL queries, improving readability and convenience when working with binary data or bitwise operations.

How to use it

Simply write numbers with the 0b prefix in your SQL queries, for example:

sql<br>SELECT 0b001;<br>

Related resources

PreviousNext