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