Function NLS_INITCAP doesn't capitalize accented characters properly

From: Menachem Rath <mrath_at_pilat.com>
Date: 2000/08/01
Message-ID: <8m7chd$ff7$1@news6.svr.pol.co.uk>#1/1

I am having problems capitalizing words with accented characters, using the NLS_INITCAP function.

Example:

SQL> select nls_initcap('abc def úu') from dual;

NLS_INITCA

---

Abc Def úU

Using a Spanish sort parameter doesn't help:

SQL> select nls_initcap('abc def úu', 'nls_sort=spanish') from dual;

NLS_INITCA

---

Abc Def úU

Any ideas why this happens? Received on Tue Aug 01 2000 - 00:00:00 CDT