Note sure what the correct settings should be, but output from SHOW ALL in psql says:
lc_collate C lc_ctype C On Mon, Oct 6, 2008 at 5:37 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: >> Scott V wrote: >>> PostgreSQL version: 8.3.1 >>> Operating system: Mac OS X 10.5.4 > >>> initcap() capitalizes incorrectly when passing strings containing certain >>> two-byte UTF-8 characters. E.g., when argument = 'mātūrāte', initcap >>> returns 'MāTūRāTe'. Correct result should be 'Mātūrāte'. > >> What's your setting for lc_collate? > > I think actually it's lc_ctype that determines case-folding. But the > current theory is that Apple's locale support is simply broken for > UTF-8: > http://archives.postgresql.org/pgsql-general/2008-02/msg01072.php > which means that even if Scott had all his settings right, it wouldn't > work :-( A quick test on OS X here seems to confirm this. > > regards, tom lane > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
