security.Base64.ToStringWithCharset

Decodes the given base64 string, according to a given charset.

Syntax

security.Base64.ToStringWithCharset(
   source STRING,
   charset STRING )
  RETURNING result STRING

source is a string encoded in base64.
charset is the character set to be used.
result is the decoded string.

Usage

Decodes the given base64 string and returns it in its clear human readable form, according to a given charset.

The original base64 encoded string is first decoded to a string that will be converted from the specified charset to the local DVM charset. In case of charset conversion error, the error -15700 is raised.

If the base64 string does not contain a human readable data, the method will raise an exception.

If the base64 string contains bytes sequences that do not match a valid character in the current encoding, the method raises a conversion error.

In case of error, the method throws an exception and sets the STATUS variable. Depending on the error, a human-readable description of the problem is available in the SQLCA.SQLERRM register. See Error handling in GWS calls (STATUS).