Re: BUG #4451: initcap() function capitalizes incorrectly

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Scott V <datagenic(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4451: initcap() function capitalizes incorrectly
Date: 2008-10-06 08:03:23
Message-ID: 48E9C64B.7080306@hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Scott V wrote:
> The following bug has been logged online:
>
> Bug reference: 4451
> Logged by: Scott V
> Email address: datagenic(at)gmail(dot)com
> PostgreSQL version: 8.3.1
> Operating system: Mac OS X 10.5.4
> Description: initcap() function capitalizes incorrectly
> Details:
>
> 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'.
>
> The function appears to be incorrectly interpreting the two-byte chars as
> non-alphamueric characters. They are in fact alphanumerics, they just have
> diacritical markings.

What's your setting for lc_collate?

//Magnus

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2008-10-06 08:10:56 Re: index bloat in 8.4-dev
Previous Message Magnus Hagander 2008-10-06 07:59:35 Re: BUG #4410: Indexes not seen right away