Answers.Body: <p>The collation in your database tables may have changed. While unusual for it to magically change it would explain it.</p>
  <p>Try e.g. <code>show create table civicrm_contact;</code> in phpmyadmin or whatever tool you use to manage the database and check what it says for collation. The expected value is utf8mb4_unicode_ci. The &quot;ci&quot; means case insensitive.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-08-30T12:31:12.613Z
Answers.Text: Thanks for the answer. It was a collation change that caused the problem.
Answers.UserDisplayName: Stephen Karamatos
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-08-29T18:52:39.013Z
Answers.LastActivityDate: 2024-08-29T18:52:39.013Z
Answers.UserDisplayName: Demerit
Body: <p>We have noticed that searches in CiviCRM are case sensitive.  Searching for community and Community return different results.  The documentation says that text searches are case insensitive.  Searches in our development install are not case sensitive.  In the past, searches worked fine.  Running verison 5.75.1.</p>
  <p>Does anyone have any suggestions on what would be causing it?  I have reviewed search preferences and looked at extensions, but can't find a reason why it behaves this way.  This is like it in quick search and advanced search.</p>
  
Tags: <search>
Title: Searching is now case sensitive
ThreadText: # Searching is now case sensitive
  
  (Asked by: username_0 on 2024-08-29)
  
  We have noticed that searches in CiviCRM are case sensitive. Searching for community and Community return different results. The documentation says that text searches are case insensitive. Searches in our development install are not case sensitive. In the past, searches worked fine. Running verison 5.75.1.
  
  Does anyone have any suggestions on what would be causing it? I have reviewed search preferences and looked at extensions, but can't find a reason why it behaves this way. This is like it in quick search and advanced search.
  
  **Tags:** search
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-08-29. Score: 2 | Accepted answer
  
  The collation in your database tables may have changed. While unusual for it to magically change it would explain it.
  
  Try e.g. `show create table civicrm_contact;` in phpmyadmin or whatever tool you use to manage the database and check what it says for collation. The expected value is utf8mb4\_unicode\_ci. The "ci" means case insensitive.
  
  > **Comments:**
  > **username_0**: Thanks for the answer. It was a collation change that caused the problem.  
  
  ---
  
  