On Fri, Jun 3, 2011 at 1:36 PM, Jeroen Vermeulen <j...@canonical.com> 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 <stu...@stuartbishop.net>
http://www.stuartbishop.net/
_______________________________________________
Mailing list: https://launchpad.net/~launchpad-dev
Post to : launchpad-dev@lists.launchpad.net
Unsubscribe : https://launchpad.net/~launchpad-dev
More help : https://help.launchpad.net/ListHelp
