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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
