Disable Case sensitivity in article search

[Former Member]

Hello!

In a newly installed CCO I am facing the problem that the article description search is "suddenly" case sensitive. E.G. the article description is "Nature" and the search only is succesfull if I enter "Nature", when I enter "nature" the search result is empty. I double checked on several other installations and the search in CCO is usually not case sensitive - And I can't find an option to change this. Is this a bug or is there a setting where I can control this?

Thank you!

[Mateus_Grings · Accepted solution]

Hi Arne,
you can find the answer for your query via KBA 2592023. Basically this depends on the database system you are using for the SAP Customer Checkout Manager.

• If the database of your Customer Checkout Manager is on SAP HANA the search is always case sensitive
• If the database of your Customer Checkout Manager is on Microsoft SQL then the search depends on your Server Collation settings:
  - if a CI (Case Insensitive) Server Collation has been set the search will be case insensitive, e.g. Latin1_General_CI_AS
  - if a CS (Case Sensitive) Server Collation has been set the search will be case sensitive, e.g. SQL_Latin1_General_CP850_BIN2
  - the recommendation for Microsoft SQL is collation SQL_Latin1_General_CP1_CI_AS (as per the SAP Customer Checkout manager Guide)
  

If your question in answered, kindly select the answer as “Right Answer”. This helps others to follow and easily locate answers.

Best Regards,
Mateus

[Former Member · Accepted solution]

Thank you Mateus, this is the answer. Unfortunately the database was created with a case sensitive server collation!