9951 explained code solutions for 126 technologies


clickhouseConvert hex to text


SELECT unhex('6578616D706C65')ctrl + c
unhex(

converts given HEX to string

6578616D706C65

HEX num to convert to text


Usage example

SELECT unhex('6578616D706C65')
output
┌─unhex('6578616D706C65')─┐
│ example                 │
└─────────────────────────┘