jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cédric Damioli <cdami...@apache.org>
Subject Re: Collating ordered query results
Date Wed, 10 Oct 2012 18:05:47 GMT
Hi guys,

Following on this, I've submitted a patch here : 
https://issues.apache.org/jira/browse/JCR-3443
I propose a new XPath function fn:normalize which works perfectly in my 
case.

I'm now awaiting your comments to know what to do with it :)

Best regards,
Cédric

Le 09/10/2012 23:00, Cédric Damioli a écrit :
> Hi team,
>
> As a French native, I often have to manipulate text containing accents.
>
> So that when I execute some Xpath query like "//text order by @title", 
> I may get a text titled "Aéroport" ordered after a text titled 
> "Avion", which is not correct.
>
> My first idea was to create a special function allowing to write 
> something like "//text order by fn:normalize(@title)" or something 
> like that. This function would consider "Aéroport" as "Aeroport", 
> leading to the expected result.
> Then I discover than, at least for Xpath, the grammar (inherited from 
> XPath 2.0) permit a more standard "//text order by @title collation 
> 'XXX'" which may also be implemented in Jackrabbit with a little more 
> work but won't be natural in SQL
>
> So my first question is : does someone already thought about 
> collations ? Possibly with an already working solution ?
> Second question : which of my two solutions fit the best in Jackrabbit 
> (or possibly a third one) ?
> And finally third question : if I implement such a collation 
> algorithm, would someone be interested to have it in the Jackrabbit 
> core ?
>
> Best regards,
>
>
> -- 
> Cédric Damioli
> Ametys CMS
> http://www.ametys.org
> http://www.anyware-services.com

Mime
View raw message