Case sensitive search on Oracle

Classic Servoy
1

Hello,

when using a search like

afield = '%aTrIck%'

on MS SQL I get records containing “Patrick”. This is because in the help I find

The default search for Servoy versions prior to 2.0 is case-sensitive. For Servoy 2.0 and above (which includes Sybase iAnywhere ASA as the installed database), the default search has been changed to case-insensitive - meaning that you no longer need to use a # symbol in front of your search criteria.

Unfortunately, this is not true on ORACLE 10g. The search is case sensitive.

Can this be changed or: how do I make the search on Oracle case insensitive?

Thanks
Patrick

2

above is only in conjuction with Sybase!

this works:

afield = '#%aTrIck%'
3

and MS SQL Server…

4

and mysql (most versions)

some databases do lowercase searching by default, others don’t

5

that clarifies things.

Thanks