Answers.Body: <p>This feature exists. It is part of MySQL and called <em>collation</em>. You can read about the background on <a href="https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html</a> .</p>
  
  <p>In my test database a search on <em>Nandor</em> returns <em>Nándor</em>. Reason <code>last_name</code> column is defined as</p>
  
  <pre><code> `last_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Last Name.'
  </code></pre>
  
  <p>and the collation <code>utf8_unicode_ci</code> defines them to be the same.</p>
  
  <p>Altering the setting with</p>
  
  <pre><code>ALTER TABLE civicrm_contact MODIFY last_name varchar(64) COLLATE latin1_bin;
  </code></pre>
  
  <p>has the effect that they are not considered the same anymore.</p>
  
  <p>What is your collation setting?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-07T14:09:20.330Z
Answers.LastActivityDate: 2017-05-07T14:09:20.330Z
Answers.UserDisplayName: Kainuk - CiviCooP
Body: <p>I'm not sure what the feature is called, but Google seems to collapse all accented letters to their base character when indexing. So a search for "Nandor" will find a record "Nándor". But searching my Civi database for the unaccented name finds no results.
  Is there a setting (either in CiviCRM or MySQL) or a plugin that would make such searches work?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-05-07T13:19:38.577Z
Comments.Text: Well, if I add a test contact named Nándor in http://dmaster.demo.civicrm.org and do a normal search from `Find Contact` with string `Nandor`, the created contact do get returned in the search result.
Comments.UserDisplayName: jitendra - fuzion
Tags: <database><search>
Title: Is smart/fuzzy searching possible in CiviCRM?
ThreadText: # Is smart/fuzzy searching possible in CiviCRM?
  
  (Asked by: username_0 on 2017-05-06)
  
  I'm not sure what the feature is called, but Google seems to collapse all accented letters to their base character when indexing. So a search for "Nandor" will find a record "Nándor". But searching my Civi database for the unaccented name finds no results.
  Is there a setting (either in CiviCRM or MySQL) or a plugin that would make such searches work?
  
  **Tags:** database, search
  
  > **Comments:**
  > **username_1**: Well, if I add a test contact named Nándor in http://dmaster.demo.civicrm.org and do a normal search from `Find Contact` with string `Nandor`, the created contact do get returned in the search result.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2017-05-07. Score: 2
  
  This feature exists. It is part of MySQL and called *collation*. You can read about the background on <https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html> .
  
  In my test database a search on *Nandor* returns *Nándor*. Reason `last_name` column is defined as
  
  ```
   `last_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Last Name.'
  
  ```
  
  and the collation `utf8_unicode_ci` defines them to be the same.
  
  Altering the setting with
  
  ```
  ALTER TABLE civicrm_contact MODIFY last_name varchar(64) COLLATE latin1_bin;
  
  ```
  
  has the effect that they are not considered the same anymore.
  
  What is your collation setting?
  
  
  ---
  
  