It sounds like Oracle is simply regexing for anything that ISN'T a letter
to initcap right after it. If that's the case, you could just regex too.
Or more likely, use the appropriate ctype.h function (isalpha, probably).
Having tested it, Oracle capitalizes after all non-alphanumeric
The initcap function is not completely consistent with Oracle's initcap
function:
SELECT initcap('alex hyde-whyte');
In Oracle 9.2i this will return 'Alex Hyde-White', in PostgreSQL 7.3.3
it returns 'Alex Hyde-white'.
It looks like a relatively simple change to oracle_compat.c in
The initcap function is not completely consistent with Oracle's initcap
function:
SELECT initcap('alex hyde-whyte');
In Oracle 9.2i this will return 'Alex Hyde-White', in PostgreSQL 7.3.3
it returns 'Alex Hyde-white'.
No, it doesn't change the 'y' to an 'i', that's a typo in my
As far as I can tell, not capitalizing the first letter after a dash
is the only inconsistency with Oracle's implementation of this function.
Wrong again. Oracle also capitalizes the first letter after a comma,
semicolon, colon, period, and both a single and double quote. (And that's
all
On Wed, 9 Jul 2003 [EMAIL PROTECTED] wrote:
As far as I can tell, not capitalizing the first letter after a dash
is the only inconsistency with Oracle's implementation of this function.
Wrong again. Oracle also capitalizes the first letter after a comma,
semicolon, colon, period, and
scott.marlowe [EMAIL PROTECTED] writes:
On Wed, 9 Jul 2003 [EMAIL PROTECTED] wrote:
Wrong again. Oracle also capitalizes the first letter after a comma,
semicolon, colon, period, and both a single and double quote. (And that's
all I've tested so far.)
It sounds like Oracle is simply