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