v.21.2New Features

Add decodeXMLComponent Function for XML Character Decoding

Official CH changelog text
Add function decodeXMLComponent to decode characters for XML. Example: SELECT decodeXMLComponent('Hello,"world"!') #17659. #18542 (nauta).
Introduces the decodeXMLComponent function to decode XML-encoded characters in strings.

Why it matters

This feature addresses the need to convert XML escape sequences (such as ") back into their corresponding characters, simplifying the processing and analysis of XML data within ClickHouse.

How to use it

Use the function by calling decodeXMLComponent with an XML-encoded string as the argument. For example: SELECT decodeXMLComponent('Hello,"world"!').

Related resources

PreviousNext