RE: Jackrabbit search does not find for umlaut character Ÿ (keyboard shortcut for this character is ALT+0159)

[Dinesh Babu <di...@pb.com>]

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: 'users@jackrabbit.apache.org'; 'dev@jackrabbit.apache.org'
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


________________________________