2808 explained code solutions for 75 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                 │
└─────────────────────────┘

link_youtube: https://youtu.be/r2o5FBOS-Vs