What are the differences between the two collation options in MySQL for sorting characters with accents?

When sorting characters with accents in MySQL, the two collation options that can be used are "utf8_general_ci" and "utf8_unicode_ci". The main difference between the two is that "utf8_general_ci" is faster but may not always provide accurate sorting results for characters with accents, while "utf8_unicode_ci" is slower but more accurate in sorting characters with accents.

// Set the collation to "utf8_unicode_ci" for accurate sorting of characters with accents
$mysqli = new mysqli("localhost", "username", "password", "database");
$mysqli->set_charset("utf8");
$mysqli->query("SET collation_connection = 'utf8_unicode_ci'");