Skip site navigation (1) Skip section navigation (2)

Fwd: BUG #1972: index error with space character

From: Eduardo RBS <edurbs(at)gmail(dot)com>
To:
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Fwd: BUG #1972: index error with space character
Date: 2005-10-18 15:32:19
Message-ID: 16ec5e7e0510180832y1c13d459t@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
---------- Forwarded message ----------
From: Eduardo RBS <edurbs(at)gmail(dot)com>
Date: 18/10/2005 13:31
Subject: Re: [BUGS] BUG #1972: index error with space character
To: Richard Huxton <dev(at)archonet(dot)com>


Hellow..
Thank you very much for the attention.
I need a locate that not ignores the space chracater and also sort
accents like á or ã.
I made configuration using locale... see it..

Using C is almost good because it sort correctly and see the spaces..
but it does not sort the portuguese accents.. note the last two
lines..
$ LC_COLLATE=C sort b.txt
aa a
aa z
aaaa
aaaz
aaz
eado
eza
édina
émaster

and with the "my" locale pt_BR it sort correctly the accents but
ignores the space chracater....
LC_COLLATE=pt_BR.utf8 sort b.txt
aa a
aaaa
aaab
aaaz
aaz
aa z
eado
édina
émaster
eza

What i need should a merge of C and pt_BR.. i mean.. a locale that see
the spaces like C but sort accents like pt_BR..
I tried several others locales.. and only C see the space character.

Thanks for the attention.

--
[]'s
Eduardo RBS
http://linuxstok.sourceforge.net


2005/10/18, Richard Huxton <dev(at)archonet(dot)com>:
> Eduardo Soares wrote:
> > Operating system:   Linux Fedora 4
> > Description:        index error with space character
> > Details:
> >
> > In above example the "AZTES Z" should be after the "AZTESA". It happens with
> > any encoding type. The DB not see the space character. The index shoulb see
> > the space and put "AZTES Z" together with "AZTES". In above list the
> > "AZTESA" should be the first.
>
> Sorting order is determined by your locale, and is different from your
> encoding. For example, en_GB ignores spaces but C doesn't:
>
> $ LC_COLLATE=en_GB.UTF-8 sort unsorted.txt
> aa a
> aaaa
> aaab
> aa b
>
> $ LC_COLLATE=C sort unsorted.txt
> aa a
> aa b
> aaaa
> aaab
>
> See "man locale" for details on how to find out what locales are setup
> on your machine. See the documentation for details on how to set locale
> on a database cluster.
>
> HTH
> --
>    Richard Huxton
>    Archonet Ltd
>


--
[]'s
Eduardo RBS
http://linuxstok.sourceforge.net

In response to

Responses

pgsql-bugs by date

Next:From: Dirk PirschelDate: 2005-10-18 17:45:32
Subject: BUG #1975: Postgres 8.0.4 build fails on AIX
Previous:From: Magnus HaganderDate: 2005-10-18 15:11:02
Subject: Re: BUG #1969: Unable to Install

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group