Re: sorting and spaces in postgresql with en_US locale

On Wed, 2004-07-21 at 20:58, Chris Kratz wrote:
> We are having a weird problem that we ran into recently.  If I use the
> following statements to create a test table and then run the select statement
> at the end, we get a very strange sort order.  It appears that to do the
> sorting, all the spaces are removed from the strings. It would appear that in
> the example below 'ab e' should be before 'abd'.

> LC_COLLATE:                           en_US
> LC_CTYPE:                             en_US

That is how the en_US (and en_GB) locales are defined.

Their sorting is dictionary style: spaces and capitalisation are
ignored.  This is a glibc issue, not a PostgreSQL issue.

--
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
     "Greater love hath no man than this, that a man lay
      down his life for his friends."      John 15:13