SQL Collation that supports both English and arabic language

Kranthi DBA 221 Reputation points
2022-06-24T13:13:27.96+00:00

Hi All,

Could you please let me know the SQL Collation that supports both English and Arabic?

I really appreciate any help you can provide.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,426 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 116.4K Reputation points MVP
    2022-06-24T21:59:35.373+00:00

    Arabic_CI_AS, Arabic_100_CS_AS_SC_UTF8 to name two. Any collation starting with Arabic should do.

    I have not tested, but I would expect an Arabic collation to handle English correctly. Since the two language uses different scripts, there is not really any conflicts, so Latin characters will be sorted and handled in a "standard" (i.e. English) way. The only reason it would not be that way, would be if Arabic imposes any particular order on Latin letters. (Which I would not expect, but I don't know Arabic.)

    I would recommend that you use nvarchar for string data, but varchar should do as well, at least to 99.5% for English. English has words like café, résumé, naïve, rôle, coöperate, but these spellings are not common.

    1 person found this answer helpful.
    0 comments No comments

  2. YufeiShao-msft 7,131 Reputation points
    2022-06-27T08:41:42.903+00:00

    Hi @Kranthi DBA ,

    You can try to use Unicode, it is designed to cover all the characters of all the languages of the world, so that you would not need different code page to handle different sets of characters, it is the easiest way to manage character data
    https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.