Skip to main content
Question

Case sensitive


Forum|alt.badge.img+3

Hello, 

Does anyone know how to turn off case sensitivity in IFS version 9?

Many thanks

This topic has been closed for comments

dhlelk
Superhero
Forum|alt.badge.img+15
  • Superhero
  • March 9, 2021

Hi @Olivia Gaches,

I hope you are referring to the search dialog match case option?
If so you could simply change the default behavior.
1. Navigate to "System Parameters" window (Solution Manager\System Parameters).
2. Search for [Parameter: Search dialog Match case Default]
3. Change the value to "OFF".

The personal profile takes precedence, hence changes are not visible if this was modified in the personal profile.

Please note that changing this option will have a negative impact on of the overall search performance of the application.

Cheers !
Dhananjaya.


Forum|alt.badge.img+3

Hi @dhlelk 

Very helpful, thank you 

May I ask you what do you mean when you say “negative impact on of the overall search performance”? 


Forum|alt.badge.img+28
  • Superhero (Customer)
  • March 10, 2021

Case sensitive searches are much faster than when the case is ignored.  Turning it off for everyone across the board by default will mean everyone’s searches will be generally slower, not to mention they will not learn the proper format of the data.

 


dhlelk
Superhero
Forum|alt.badge.img+15
  • Superhero
  • March 10, 2021

 Hi @Olivia Gaches,

 

Olivia Gaches wrote:

Hi @dhlelk 

Very helpful, thank you 

You are welcome and I'm happy to help 😊

 

Olivia Gaches wrote:

May I ask you what do you mean when you say “negative impact on of the overall search performance”? 

When you untick the match case option on the search dialog, it wraps each column and respective search expression with an UPPER() function.
Having function calls in a where clause reduces the performance on your queries since the standard indexes won't be considered.
Therefore, case in-sensitive searches are relatively slower than case sensitive searches.
Hence, it's recommended to keep "Search dialog Match case Default" value as "ON".

 

Cheers !
Dhananjaya.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings