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

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Scott Vanderbilt <datagenic(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4451: initcap() function capitalizes incorrectly
Date: 2008-10-06 16:01:46
Message-ID: 48EA366A.8050601@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Scott Vanderbilt wrote:
> Note sure what the correct settings should be, but output from SHOW
> ALL in psql says:
>
> lc_collate C
> lc_ctype C

There's a chapter on locale support in the user manual:

http://www.postgresql.org/docs/8.3/interactive/locale.html

The right setting depends on what language's collation rules you want to
follow. "locale -a" in a shell should list the available options.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Davis 2008-10-06 20:36:33 Re: index bloat in 8.4-dev
Previous Message Scott Vanderbilt 2008-10-06 15:50:11 Re: BUG #4451: initcap() function capitalizes incorrectly