title: Mysql search interprets european character as non-european character
body: <p>When I do a search on a string containing the letter "a", that letter also matches words containing the letter "ä" and "å".</p>
  
  <p>So if I search for "anna" it matches a text containing "känna". If I search for "manda" it matches "månda".</p>
  
  <p>The database character set is:  <code>latin1</code>
  The table character set: <code>utf8mb4</code></p>
  
  <p>I can test it by searching a particular row and a particular column:</p>
  
  <pre><code>SELECT * FROM events AS e  
  WHERE e.content LIKE '%anna%' AND e.id = 1230 
  </code></pre>
  
  <p>That would return that row (1230). If I remove the line containing "känna" from the "content" column of that row, there will be no match. So it interprets all european characters based on "a" as also being "ä", or "å".</p>
  
  <p>How do I correct this?</p>
  
  <p><strong>edit</strong>:</p>
  
  <p>okay, here is a fiddle:
  <a href="http://sqlfiddle.com/#!9/2445bd/1" rel="nofollow noreferrer">fiddle</a></p>
  
  <p><strong>Show create table events output:</strong> (I removed some columns):</p>
  
  <pre><code>CREATE TABLE `events` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
   `content` longtext COLLATE utf8mb4_unicode_ci,
   `event_at` timestamp NULL DEFAULT NULL,
   `created_at` timestamp NULL DEFAULT NULL,
   `updated_at` timestamp NULL DEFAULT NULL,
   PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1242 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
  </code></pre>