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

Well, I can confirm it's an issue for me on MySQL. It raises an Xwiki exception, though it's not clear if the exception is bubbling up from hibernate, or from xwiki itself. According to the v3 hibernate docs (not sure what vers of hib xwiki uses), it is supposed to be supported - search for "insensitive" on the hibernate docs site; returns three results, first one covers ilike. One would think the hibernate.cfg.xml allows you to remap key things like the ilike/like, etc; but failing that, perhaps instead of "fixing" this as a hardcoded change,: How about a new config set for the xwiki.cfg file? So then if someone uses an odd database, supporting it should not require added effort (just checking keywords). For example, replacing like and % (memory scratchy, but iirc postgresql supports _ as well as % for single wildcards?). hibernate.replace.list=like,%,' <the list is used so that you're not constantly scanning the whole config file for replacements> hibernate.replace.like=ilike hibernate.replace.%=_ hibernate.replace.'='' The last one there would be a godsend as you often get users that stick in a ' that needs to be escaped, though you can use .replace(), it's still tacky that way. -----Original Message----- From: Vincent Massol [mailto:vincent@massol.net] Sent: 27 March 2007 20:42 To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] Re: Case insensitive search On Mar 27, 2007, at 9:33 PM, Zeljko Trogrlic wrote: I don't think it should be done in Velocity at all. We could do it in Java, in the search implementations. Again, I don't know how this works (or doesn't work) in Hibernate. I'm just making sure we've covered all angles before deciding. Thanks -Vincent