Arabic Case Insensitive In Database Systems: How To Solve Alef With and Without Hamza Problem
<p>When I first started learning database systems, I ran into problems dealing with Arabic text in databases. Since these problems were specific to the Arabic language, I couldn’t easily find solutions on the internet. I try in this post to summarize the solutions I know to a common Arabic text problem in database systems, hoping it will help someone struggling to deal with Arabic text in databases.</p>
<p>You have characters which are considered the same in Arabic (like Alef <code>'ا'</code> and Alef with Hamza <code>'أ'</code>), but these are two different characters in database systems. When you try to make a search function in your website, for example, you want to ignore the differences between these characters. The use of case-insensitive collation like <code>utf8_unicode_ci</code> won’t solve the problem. </p>
<p><a href="https://a-essam.medium.com/arabic-case-insensitive-in-database-systems-how-to-solve-alef-with-and-without-hamza-problem-c54ee6d40bed"><strong>Learn More</strong></a></p>