Forum

This content is now out of date.

Visit Our Community

Case Sensitivity in Filters

Is there a way for YF to ignore case in a filter? (ie. I want to return all results containing "Sydney" regardless if I filter by "SYDNEY", "sydney", etc.

Thanks.
Hi Yaniv,

Yellowfin has nothing to do with the case sensitivity, it's all about your database.

If I remember correctly and you're indeed using Oracle, and if your Oracle version is 10gR2 or higher, then setting the following parameters: NLS_COMP=LINGUISTIC and NLS_SORT=BINARY_CI; and having linguistic indexes created for your tables should let you use case insensitive search.

Please refer to this web page for more information:
http://docs.oracle.com/cd/B28359_01/server.111/b28298/ch3globenv.htm#i1008393

Kind Regards,
Artem

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.