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

Re: BUG #1972: index error with space character

From: Richard Huxton <dev(at)archonet(dot)com>
To: Eduardo Soares <edurbs(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1972: index error with space character
Date: 2005-10-18 13:15:53
Message-ID: 4354F589.5070004@archonet.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-10-18 14:30:04
Subject: Re: BUG #1971: Start Transaction is giving Errors !!!
Previous:From: Thomas ReissDate: 2005-10-18 13:00:03
Subject: BUG #1974: UTF-8 french postmaster messages corrupted

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