BUG #4451: initcap() function capitalizes incorrectly

From: "Scott V" <datagenic(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4451: initcap() function capitalizes incorrectly
Date: 2008-10-06 04:01:09
Message-ID: 200810060401.m96419cn021991@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Davis 2008-10-06 07:03:40 index bloat in 8.4-dev
Previous Message Cadu 2008-10-06 01:02:05 RES: BUG #4450: Postgres do not ask for passord