---------- 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>
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
$ LC_COLLATE=C sort b.txt
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
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.
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
> aa b
> $ LC_COLLATE=C sort unsorted.txt
> aa a
> aa b
> 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.
> Richard Huxton
> Archonet Ltd
In response to
pgsql-bugs by date
|Next:||From: Dirk Pirschel||Date: 2005-10-18 17:45:32|
|Subject: BUG #1975: Postgres 8.0.4 build fails on AIX|
|Previous:||From: Magnus Hagander||Date: 2005-10-18 15:11:02|
|Subject: Re: BUG #1969: Unable to Install|