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.

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:

Kind Regards,

Thanks for trying Yellowfin

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