From: | Sergey Levchenko <sector119(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgresql unicode lower/upper problem |
Date: | 2005-03-24 09:44:36 |
Message-ID: | e3ffbf240503240144185c88d5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I modify pg_createcluster and add locale options
exec $initdb, '--locale', 'ru_RU.UTF-8', '--encoding', 'UTF-8', '-D', $datadir
then drop and create cluster with my locale. now lower and upper work
good with unicode.
P.S.
it's bad that we can not modify lc_ctype and lc_collate from
postgresql.conf like lc_messages, lc_monetary, ...
I think that it will be good idea to add locale specific options to
pg_createcluster...
On Wed, 23 Mar 2005 12:17:14 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Sergey Levchenko <sector119(at)gmail(dot)com> writes:
> > I am not able to get work lower and upper functions on postgresql
> > v8.0.1 and 8.1b(current cvs copy). I use Debian SID i686 GNU/Linux.
> > Locale: ru_RU.KOI8-R
>
> > createdb -E UNICODE test
>
> I think the problem is you selected a database encoding that doesn't
> match what the locale expects. You can't really mix-and-match if you
> expect locale-specific stuff like upper/lower to work. For that
> locale you must use -E KOI8.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2005-03-24 10:15:45 | Re: multi line text data/query ?bug? |
Previous Message | Sim Zacks | 2005-03-24 07:24:11 | Re: multi line text data/query ?bug? |