v.23.7New Feature
Added initcap and initcapUTF8 Functions for Capitalization
Added newinitcap/initcapUTF8functions which convert the first letter of each word to upper case and the rest to lower case. #51735 (Dmitry Kardymon).
Why it matters
These functions address the need for proper capitalization formatting of text data by transforming each word to start with an uppercase letter followed by lowercase letters, improving data presentation and consistency.How to use it
Use theinitcap or initcapUTF8 functions in your queries by passing a string argument to convert it accordingly, for example: SELECT initcap(column_name) FROM table;.