 <p>change the field collation to :-</p> <pre><code>utf8_general_ci </code></pre> <p><a href="https://i.stack.imgur.com/hlt7s.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hlt7s.png" alt="enter image description here"></a></p>