> > 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-alphanumeri
"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
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,
> 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 I
>
> 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 i
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
backend/ut
