Re: Case insensitive string comparison?

No.  To keep it simple, SQuery is only designed to cover the 80% of easy, common cases.  The others can be dealt with using rawPredicate as you mention.  

SQL 92 functions such as LOWER are generally available on most databases -- even Oracle supports it. 

But real database independence is not that simple.  If your database supports indexing of the LOWER of the actual value, then you would do it in the query.  If not, then you would store the data LOWERED, and do it in SQL.  

Real database independence is very hard, and Hibernate et. al. only goes part way at the cost of huge complexity.

Anthony

At 06:01 AM 10/12/2008, you wrote:

>Is there any way to do case insensitive string comparison with SQuery without resorting to rawPredicate? If not, it seems that all the drivers would need to know is the LOWER function for their particular dialect. 
>
>
>Thanks,
>Carl Gould
>Inductive Automation 
> 


Spreadsheet Detective,
Southern Cross Software Queensland Pty Limited
54 Gerler Street
Bardon, Queensland 4065, Australia.

Email: [email protected]
www.SpreadsheetDetective.com
Ph: +61 427 830248 (Australian Eastern Standard Time)

"If the model seems correct only because the numbers look right, 
then why build the model in the first place?"

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/SimpleORM/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[email protected] 
    mailto:[email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/