Hi all, i'm workink on a railo based app, where the datasource is anh h2 db in mysql compatibility. this app uses the dataMgr tool, but i think it is not important. in my app i run a lot of query with matching condition, i.e. SELECT ... WHERE ... LIKE 'xxx%' SELECT ... WHERE ... LIKE '%xxx' SELECT ... WHERE ... LIKE '%xxx%' i noted that this search is case sensitive but i need to be able to set if the matching must be case sensitive or not. example: in a table User a column name contains "Salvatore" i need to be able to specify if researsh must be case sensitive or not:
case sensitive = true: SELECT ...... WHERE name='Sal%' : return 1 record SELECT ...... WHERE name='sal%' : return 0 record case sensitive = false SELECT ...... WHERE name='Sal%' : return 1 record SELECT ...... WHERE name='sal%' : return 1 record is this possible? thannks and regards Salvatore -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
