v.21.1New Features
Add encodeXMLComponent function for XML character escaping
Add function encodeXMLComponent to escape characters to place string into XML text node or attribute. #17659 (nauta).Why it matters
This feature provides a reliable way to escape characters that are problematic in XML content, preventing XML syntax errors and ensuring correct data representation when embedding strings into XML structures.How to use it
Use theencodeXMLComponent function in your SQL queries to transform strings for safe XML embedding. For example:SELECT encodeXMLComponent(your_string_column) FROM your_table;