Fwd: BUG #1972: index error with space character - Mailing list pgsql-bugs

From Eduardo RBS
Subject Fwd: BUG #1972: index error with space character
Date
Msg-id 16ec5e7e0510180832y1c13d459t@mail.gmail.com
Whole thread Raw
In response to BUG #1972: index error with space character  ("Eduardo Soares" <edurbs@gmail.com>)
Responses Re: Fwd: BUG #1972: index error with space character
List pgsql-bugs
---------- Forwarded message ----------
From: Eduardo RBS <edurbs@gmail.com>
Date: 18/10/2005 13:31
Subject: Re: [BUGS] BUG #1972: index error with space character
To: Richard Huxton <dev@archonet.com>


Hellow..
Thank you very much for the attention.
I need a locate that not ignores the space chracater and also sort
accents like =E1 or =E3.
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=3DC sort b.txt
aa a
aa z
aaaa
aaaz
aaz
eado
eza
=E9dina
=E9master

and with the "my" locale pt_BR it sort correctly the accents but
ignores the space chracater....
LC_COLLATE=3Dpt_BR.utf8 sort b.txt
aa a
aaaa
aaab
aaaz
aaz
aa z
eado
=E9dina
=E9master
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@archonet.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=3Den_GB.UTF-8 sort unsorted.txt
> aa a
> aaaa
> aaab
> aa b
>
> $ LC_COLLATE=3DC 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

pgsql-bugs by date:

Previous
From: "Dirk Pirschel"
Date:
Subject: BUG #1975: Postgres 8.0.4 build fails on AIX
Next
From: Tom Lane
Date:
Subject: Re: Fwd: BUG #1972: index error with space character