| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | Scott V <datagenic(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4451: initcap() function capitalizes incorrectly |
| Date: | 2008-10-06 12:37:08 |
| Message-ID: | 18902.1223296628@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Magnus Hagander <magnus(at)hagander(dot)net> 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 = 'mtrte', initcap
>> returns 'MTRTe'. Correct result should be 'Mtrte'.
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Vanderbilt | 2008-10-06 15:50:11 | Re: BUG #4451: initcap() function capitalizes incorrectly |
| Previous Message | Magnus Hagander | 2008-10-06 12:29:59 | Re: BUG #4447: install failed to start; libintl3.dll was not found |