When we are using SQL server and executing broker queries (Tridion Content Delivery API) the results returned are case insensitive.
However while doing same with ORACLE DB results returned are case sensitive.
We want results to be case insensitive. Could you please help us on below points?
- Since our DB is shared by other applications, is there a way that we can have some setting at instance level only?
- Would we need to install any patch to return results as case insensitive?
Please suggest what normally is done in case we use ORACLE as a DB and need case insensitive results.
We are using following settings :
- Content Delivery Server : Windows server 2008 R2 64-Bit
- CMS : Tridion 2011SP1
- Broker Database: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit PL/SQL Release 18.104.22.168.0 CORE 22.214.171.124.0