Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4451: initcap() function capitalizes incorrectly - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: BUG #4451: initcap() function capitalizes incorrectly
Date
Msg-id 48E9C64B.7080306@hagander.net
Whole thread Raw
In response to BUG #4451: initcap() function capitalizes incorrectly  ("Scott V" <datagenic@gmail.com>)
Responses Re: BUG #4451: initcap() function capitalizes incorrectly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
Scott V wrote:
> The following bug has been logged online:
>
> Bug reference:      4451
> Logged by:          Scott V
> Email address:      datagenic@gmail.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

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #4410: Indexes not seen right away
Next
From: Heikki Linnakangas
Date:
Subject: Re: index bloat in 8.4-dev