[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: Locale dependent collation for server side sorting

Jonathan SÃssemilch Poulain wrote:

Not as far as I know, other directory servers such as OpenDJ seem to support
that
(http://opendj.forgerock.org/opendj-server/configref/collation-matching-rule.html).
But to my knowledge there is nothing similar in OpenLDAP.
There's no published LDAP spec for a collation matching rule, but if you can dig up a formal definition (OIDs etc) I'm sure it could be added. 

/Jonathan


On Thu, May 22, 2014 at 10:07 PM, Jonas Israelsson <jonas@israelsson.com
<mailto:jonas@israelsson.com>> wrote:


    On 21/05/14 11:33, Jonas Israelsson wrote:

    Greetings.

    We have some challenges regarding Server Side Sorting, where is does not
    really sort the way we want it to. In UTF-8 the character Ã/Ã (c3 85/c3
    a4) comes before Ã/Ã (c3 84/c3 a5) whereas in our (swedish) alphabetic
    order it should be the other way around.

    Server Side Sorting seem to blindly fall back on the sorting order of UTF-8

    isrjo@svarde:~> ldapsearch -E 'sss=sn:caseIgnoreOrderingMatch' -x -H
    ldaps://myserver:636 -D uid=myuser,ou=applications,o=myorg -w mypass -b
    ou=people,o=myorg -s sub gn=sortme sn gn description

    # extended LDIF
    #
    # LDAPv3
    # base <ou=people,o=myorg> with scope subtree
    # filter: gn=sortme
    # requesting: sn gn description
    # with server side sorting control
    #

    # angla, people, Myorg
    dn:uid=angla,ou=people,o=Myorg
    givenName: sortme
    sn:: w4RuZ2x1bmQ=
    description: SN BEGINNING WITH LATIN CAPITAL LETTER A WITH DIAERESIS

    # 19f98ab4-7beb-4703-82ec-df970944ef30, people, Myorg
    dn: cn=19f98ab4-7beb-4703-82ec-df970944ef30,ou=people,o=Myorg
    sn:: w4VrZXNzb24=
    givenName: sortme
    description: SN BIGGING WITH LATIN CAPITAL LETTER A WITH RING ABOVE

    # search result
    search: 2
    result: 0 Success
    control: 1.2.840.113556.1.4.474 false MAMKAQA=
    sortResult: (0) Success

    # numResponses: 3
    # numEntries: 2

    I fail in openldap to find any matching rule or any other way such as
    setting the locale before starting the slapd daemon that changes the
    sorting order.
    Does anyone know if it is possible to specify a locale dependent
    collation for server side sorting?

    Rgds Jonas



    Anyone ?





--
  -- Howard Chu
  CTO, Symas Corp.           http://www.symas.com
  Director, Highland Sun     http://highlandsun.com/hyc/
  Chief Architect, OpenLDAP  http://www.openldap.org/project/