v.22.2Improvement

Fixed UTF-8 Case-Insensitive Search for Multi-Byte Characters

Official CH changelog text
Fixed UTF-8 string case-insensitive search when lowercase and uppercase characters are represented by different number of bytes. Example is ẞ and ß. This closes #7334. #33992 (Harry Lee).
Fixed UTF-8 string case-insensitive search handling for characters where lowercase and uppercase forms use different byte lengths, such as ẞ and ß.

Why it matters

To resolve incorrect results in case-insensitive string comparisons involving UTF-8 characters that differ in byte length between their uppercase and lowercase forms. This improves accuracy and reliability of LIKE and other case-insensitive search operations on such characters.

How to use it

Users can benefit from this fix automatically as it improves the built-in behavior of case-insensitive string operations. No additional configuration or syntax changes are required.

Related resources

PreviousNext