Case Sensitive

mfauzi · Post by **mfauzi** » Wed Jan 14, 2015 2:43 am

In our queries AW will display the result in a grid. All the queries has the filter at the top of the grid.

My issue is:
1. How can I disable the case sensitive in the filter . Currently user need to enter accurate case for the filter in order for it to properly filter .

2. How can the queries to disable case sensitive duri appreciated.ng the db queries. I am using oracle

Any suggestion or direction is really

crisg0112 · Post by **crisg0112** » Thu Jan 15, 2015 12:43 am

Hi,

I am not 100% sure about Oracle, but you might try setting this on your session in ORACLE not AWAREIM

alter session set NLS_SORT = GENERIC_BASELETTER;

From our app, we don't have such issues in MSSQL, the filter on top of the query returns both upper and lower-case.

I haven't used Oracle for a long time but give that a try. I am sure that it is Oracle you have to set to remove the case sensitivity.

Hope this helps