title: AWS Aurora MySQL 5.7.12 accent sensitive collation
body: <p>A legacy SQLServer db column has the collation SQL_Latin1_General_CP1_CI_AS (Case Insensitive, Accent Sensitive).</p>
  
  <p>We need to migrate this column into an already created and actively used AWS Aurora MySQL instance.</p>
  
  <p>MySQL 8 has the collation utf8mb4_0900_as_ci (Case Insensitive, Accent Sensitive).</p>
  
  <p>AWS Aurora however currently uses MySQL 5.7.12 which does NOT have utf8mb4_0900_as_ci. MySQL 5.7.12 does have </p>
  
  <ul>
  <li>utf8mb4_bin (Case Sensitive, Accent Sensitive as it is comparing binary)</li>
  <li>utf8mb4_unicode_ci (Case Insensitive, haven't been able figure out if it's Accent Sensitive)</li>
  <li>utf8mb4_unicode_520_ci (Case Insensitive, haven't been able figure out if it's Accent Sensitive)</li>
  </ul>
  
  <p>Are utf8mb4_unicode_ci or utf8mb4_unicode_520_ci accent sensitive? If yes, can I just use one of them (but which?).</p>
  
  <p>Otherwise, I see no other option but using utf8mb4_bin as it appears to be the only accent sensitive collation available, but because it is Case Sensitive I would have to work around the case sensitivity by eg lowercasing in WHERE clauses, but will that work without unintended undesirable side effects?</p>