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&rsquo;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&nbsp;<code>&#39;ا&#39;</code>&nbsp;and Alef with Hamza&nbsp;<code>&#39;أ&#39;</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&nbsp;<code>utf8_unicode_ci</code>&nbsp;won&rsquo;t solve the problem.&nbsp;</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>
Tags: Hamza Problem