How does the use of utf8_unicode_ci collation affect the handling of languages that read from right to left in PHP?

When using utf8_unicode_ci collation in PHP, it may not handle languages that read from right to left correctly, such as Arabic or Hebrew. To solve this issue, you can set the collation to utf8_general_ci, which is more suitable for handling right-to-left languages.

// Set the collation to utf8_general_ci for handling right-to-left languages
mysqli_set_charset($connection, "utf8_general_ci");