VARBINARY_TO_STRING

VARBINARY_TO_STRING(inputBytes, charSet) converts input bytes into the character string in the supplied character set.

where:

  • inputBytes is a binary-typed expression.
  • charset is the name of a java.nio.charset.Charset visible to the server JVM.

Example:

0: jdbc:sqlstream:sdp://slabprod> values varbinary_to_string(varchar_to_varbinary('4142432061626320313233'),'UTF-8');
'EXPR$0'
'ABC abc 123'