Got more info on this. This looks like a jackrabbit defect.
Jackrabbit search query for exact term which contains the capital umlaut
character Ÿ does not work as long as the term does not start with this letter.
Only LIKE search works for this scenario. The lower case ÿ works fine. All
other omlaut characters upper/lower case work fine.
This is the following query that we fire which does not work
SELECT * FROM [pb:community] WHERE ISDESCENDANTNODE('/community') AND (
LOWER([jcr:title]) = LOWER('umlautŸ' ))
But If I change the query to as below it does work. But we can't do it as we
have to do an exact search
SELECT * FROM [pb:community] WHERE ISDESCENDANTNODE('/community') AND (
LOWER([jcr:title]) LIKE LOWER('%umlautŸ%) )
On further investigation I found that exact search query works if we don't use
LOWER in the query . ie.,
SELECT * FROM [pb:community] WHERE ISDESCENDANTNODE('/community') AND (
[jcr:title] = 'umlautŸ' ).
Regards,
Dinesh Babu
From: Dinesh Babu
Sent: 17 April 2015 11:36
To: '[email protected]'; '[email protected]'
Subject: Jackrabbit search does not find for umlaut character Ÿ (keyboard
shortcut for this character is ALT+0159)
Hi,
I am a newbie here.
Jackrabbit search query for exact term Ÿ does not work. Only LIKE search works
for this character
This is the following query that we fire which does not work
SELECT * FROM [pb:com] WHERE ISDESCENDANTNODE('/com') AND ( LOWER([jcr:title])
= 'ÿ' )
But If I change the query to as below it does work.
SELECT * FROM [pb:com] WHERE ISDESCENDANTNODE('/com') AND ( LOWER([jcr:title])
LIKE '%ÿ'% )
Does anyone whether this is a jackrabbit defect? I would like to get the exact
search work for our development.
Regards,
Dinesh Babu
Pitney Bowes Software
6 Hercules Way, Leavesden Park, Watford, Herts WD25 7GS
________________________________
