Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

can't distinguish some arabic characters when querying in sql server

Tags:

sql

sql-server

when I search about some arabic words in sql server , it doesn't distinguish between 'ة' and 'ت' and it shows them all

like in this picture

enter image description here

like image 753
Aya Ka Avatar asked Sep 17 '25 09:09

Aya Ka


1 Answers

Try to collate them as

where emp_firstname collate Arabic_BIN = N'نعمت'
like image 80
Yogesh Sharma Avatar answered Sep 20 '25 02:09

Yogesh Sharma