On 05.09.2006, at 18:57, Thomas Martin wrote:
Hi Boris
Thanks for the explanation.
One question still remains:
Do I interpret your post correctly if I read:
substituting "like" by "contains" in an sql search statement
through info.magnolia.cms.core.search.QueryManager does not deliver
case insensitive results (as opposed to Sameers mail from august 31)?
if so I can start hacking workarounds if not it would be obvious
that I'm doing something wrong and hence I would appreciate very
much pointers where I can find out more about the proper syntax/usage.
If my words allow an interpretation like the above one I should apply
for the job as next Fed's chairman ;-)
Honestly, I have no idea. There are several issues at hand
* maybe the query manager has a problem. So use any shell of your
liking to query the repository directly, and see if it works. File an
issue if so.
* "contains" is case insensitive, but it might not always be what you
need (IIRC it uses a full text index that also indexes node names etc.)
* performance-wise its probably smarter to do it the old-fashioned
way, but who knows what database smarts have recently come up with?
If all else fails you can always by a Google appliance, I hear they
are painless to setup and maintain. ;-)
Maybe someone can post a specific query example?
- Boris
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
