FROM_BINARY

Converts a binary value to a VARCHAR string based on the specified binary format.

Analyze Syntax

func.from_binary(<binary>, <format>)

Analyze Examples

func.from_binary(b'\x48\x65\x6c\x6c\x6f', 'utf8')

┌─────────┐
 'Hello'  
└─────────┘

SQL Syntax

FROM_BINARY(<binary>, <format>)

SQL Examples

SELECT FROM_BINARY(X'48656C6C6F', 'utf8');

┌───────┐
 Hello  
└───────┘