anthonylouisbsb opened a new pull request #10604: URL: https://github.com/apache/arrow/pull/10604
The current behavior of the INITCAP function is to turn the first character of each word uppercase and remains the other as is. The desired behavior is to turn the first letter uppercase and the other lowercase. Any character except the [lowercase letters](https://www.compart.com/en/unicode/category/Ll), [uppercase letters](https://www.compart.com/en/unicode/category/Lu) and [decimal numbers](https://www.compart.com/en/unicode/category/Nd) ones should be considered as a word separator. That behavior is based on these database systems: - [Oracle](https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions065.htm) - [Postgres](https://w3resource.com/PostgreSQL/initcap-function.php) - [Redshift](https://docs.aws.amazon.com/redshift/latest/dg/r_INITCAP.html) - [Splice Machine](https://doc.splicemachine.com/sqlref_builtinfcns_initcap.html) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
