ETL: ByteArrayToString

Convert a byte array with a specified character encoding into a readable string. Use for binary-to-text conversions in ETL data pipelines.

Description

Converts a byte array in a given encoding to string.

Syntax

ByteArrayToString(byte_array[, charset_expression])

Arguments

byte_array - a byte array.

charset_expression - string_expression indicating the input encoding. The default is UTF-8. See the list of available character sets in https://docs.oracle.com/javase/7/docs/technotes/guides/intl/encoding.doc.html.

Examples

ByteArrayToString(GetBytes('Hello World','UTF-8'),'UTF-8') returns ‘Hello World’

Return value datatype

string

Impact of null value

If either parameter is null or not provided, returns null.