News
Abstract
HTML_ENTITY_DECODE and HTML_ENTITY_ENCODE scalar functions decode and encode HTML entities in a string.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > HTML_ENTITY_DECODE and HTML_ENTITY_ENCODE scalar functions
The HTML_ENTITY_DECODE scalar function returns a character string in which HTML entities have been decoded into their corresponding character values. The function can be used to convert HTML data containing HTML entities received from a web service into the corresponding character data.
The HTML_ENTITY_ENCODE scalar function converts a string into a string containing HTML entities.
See the SQL Reference for details:
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
10 October 2023
UID
ibm17031287