v.22.12Improvement
unhex function now supports FixedString arguments
Theunhexfunction now supportsFixedStringarguments. issue42369. #43207 (DR).
Why it matters
Previously, theunhex 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 theunhex function with FixedString arguments as you would with String types. For example:SELECT unhex(fixed_string_column) FROM table_name;