v.22.12Improvement

unhex function now supports FixedString arguments

The unhex function now supports FixedString arguments. issue42369. #43207 (DR).
The unhex function now supports FixedString arguments in addition to its existing input types.

Why it matters

Previously, the unhex function did not accept FixedString arguments, limiting its usability with fixed-length string data types. This update allows users to directly apply unhex to FixedString inputs, simplifying queries and enhancing compatibility.

How to use it

Use the unhex function with FixedString arguments as you would with String types. For example:

SELECT unhex(fixed_string_column) FROM table_name;