Hi Stèphane,
LIKE is case sensitive so you should use "CONTAINS" if you wanna case
insensitive search.
Regards,
Sameer Charles
Magnolia International Ltd.
------------------------------------------------------------------------
---------
[EMAIL PROTECTED] http://www.magnolia.info
Magnolia® - Simple Enterprise Content Management
------------------------------------------------------------------------
---------
On Aug 31, 2006, at 3:54 PM, Gauthier, Stephane (CH Temp) wrote:
Hi Magnolians,
Does someone knows how to make JCR-SQL searchs that are not case
sensitive?
Ex. Keywords like '%whatever%' matches only 'whatever' and not
'Whatever'
Could be something in a configuration file?
Many thanks for your help.
Stéphane Gauthier
Webmaster * IT
Lloyds TSB International Private Banking
**********************************************************************
**************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have received this email in error, please notify the system
manager ([EMAIL PROTECTED]) and delete the message with any
attached files from your system.
The confidentiality and integrity of this message cannot be
guaranteed on the Internet and the sender does not accept liability
for its content.
**********************************************************************
*************
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
