Case Sensitivity in Filters
7 August, 2014
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.
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
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