launchpad-dev team mailing list archive

[Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>]

On Fri, Jun 3, 2011 at 1:36 PM, Jeroen Vermeulen <jtv@xxxxxxxxxxxxx> wrote:

>> Ideally the sort would be consistent with whatever psql does.  (Or is
>> it maybe case sensitive?)
>
> PostgreSQL has configurable locales, so there's probably a range of options
> there.  Perfect consistency is probably more trouble than it's worth, but if
> Unicode Snowman is sorted in the wrong place I suspect only Paul Hummer is
> going to notice.

We discussed this on IRC. Consensus was that it is actually rare for
us to do sorting in the DB where this is a problem:

    - We order people by displayname (should be lower(displayname) to
take advantage of the index we just created now I think of it) due to
a PG bug that makes it impractical to order by the displayname_sort()
function created for this purpose.

    - We might want to order distributions, products, projects etc.
by title rather than name. But name seems to be working fine and not a
problem since we restrict them to lowercase ascii.

So we should deal with the Python side locale/collation issues
separately from the PostgreSQL side.

-- 
Stuart Bishop <stuart@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/