Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott V
Subject BUG #4451: initcap() function capitalizes incorrectly
Date
Msg-id 200810060401.m96419cn021991@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4451: initcap() function capitalizes incorrectly  (Magnus Hagander <magnus@hagander.net>)
List pgsql-bugs
Tree view 
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.

pgsql-bugs by date:

Previous
From: "Cadu"
Date:
Subject: RES: BUG #4450: Postgres do not ask for passord
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #4410: Indexes not seen right away