v.23.1New Feature

Support for SQL Standard Binary and Hex String Literals

Official CH changelog text
Support SQL standard binary and hex string literals. #43785 (Mo Xuan).
Added support for SQL standard binary and hexadecimal string literals in ClickHouse.

Why it matters

This feature enables users to write binary and hex string literals using the SQL standard syntax, improving compatibility and expressiveness when dealing with binary data in queries.

How to use it

Users can now write binary literals using the B'...' syntax and hexadecimal string literals using the X'...' syntax directly in SQL queries.

Related resources

PreviousNext