v.24.9Improvement

Functions upperUTF8 and lowerUTF8 now support case conversion for all languages

Official CH changelog text
Functions upperUTF8 and lowerUTF8 were previously only able to uppercase / lowercase Cyrillic characters. This limitation is now removed and characters in arbitrary languages are uppercased/lowercased. Example: SELECT upperUTF8('Süden') now returns SÜDEN. #65761 (李扬).
The upperUTF8 and lowerUTF8 functions now support uppercasing and lowercasing characters from arbitrary languages, beyond just Cyrillic characters.

Why it matters

Previously, these functions only transformed Cyrillic characters, limiting their use for multilingual text processing. This update removes that limitation, enabling accurate case conversion for a wide range of UTF-8 encoded characters, enhancing internationalization support.

How to use it

Use the upperUTF8 and lowerUTF8 functions as before, for example:

sql<br>SELECT upperUTF8('Süden')<br>

This will now correctly return SÜDEN for strings containing accented or non-Cyrillic characters.

Related resources

PreviousNext