RE: [xwiki-users] Re: Case insensitive search

Hmm, my origional reply got rejected/did not send for some reason.. Problem is that MySQL is default case-insensitive; so LIKE is working fine for MySQL queries. eg: select doc.name from XWikiDocument doc where doc.fullName like '%thistest' above will be case-insensitive on MySQL. PostgreSQL treats LIKE queries as case-sensitive; so to make it case-insensitive you would have to use ilike (extra i in front of like) to make it case-insensitive. eg: select doc.name from XWikiDocument doc where doc.fullName ilike '%thistest' above (should, far as I can recall) be case-insensitive on PostgreSQL, but again may not work with MySQL. I would have thought Hibernate fixes this kind of discrepency though? ________________________________ From: Sergiu Dumitriu [mailto:sergiu.dumitriu@gmail.com] Sent: 27 March 2007 08:50 To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] Re: Case insensitive search On 3/27/07, Zeljko Trogrlic <zeljko_t(a)post.htnet.hr> wrote: I search for "Available." then it this issue I'm using PostgreSQL as backend, could that be the source of the problem? How actually searching works? Using database functions? If you give me a hint where is it done (in code) I can investigate the problem. Check the code for Main.WebSearch , its a series of hibernate hql queries. The string is searched with "where field LIKE '$keyword'", so if LIKE is not case insensitive, this is the cause. I turn on search a search Code area It was not clear to me does it replace regular search, thanks for the answer. I will add search box integration to JIRA for future reference, and I think that this should be stated on plugin page, because description is a bit misleading: "It can be used in place of the default search implementation..." Sergiu -- http://purl.org/net/sergiu