v.19.6New Features
Added New Function Isvalidutf8 for Checking Whether a Set of Bytes Is Correctly Utf-8 Encoded
Added new function isValidUTF8 for checking whether a set of bytes is correctly utf-8 encoded. #4934 (Danila Kutenin)Why it matters
This feature addresses the need to validate UTF-8 encoding correctness in data, helping users identify and handle encoding errors effectively within ClickHouse.How to use it
Use theisValidUTF8 function in your queries by passing the byte sequence or string you want to check. It returns a boolean indicating whether the input is valid UTF-8 encoded bytes.