SQL Server 2000 replication allows you to copy, distribute, and modify data across your enterprise. SQL Server 2000 includes several methods and options for replication design, implementation, monitoring, and administration to give you the functionality and flexibility needed for distributing data and maintaining data consistency.
Replication offers various benefits depending on the type of replication and the options you choose, but the common benefit of SQL Server 2000 replication is the availability of data when and where it is needed.

When you have Arabic data, consider the following:
If replication is implemented between servers using different character sets, SQL Server 2000 does not convert any of the replicated data and may mistranslate the data as it is replicated, because it is impossible to map all characters between character sets.
To guarantee successful data replication, therefore, servers are best configured using the same Arabic code pages and comparison styles.
You may consider setting up your SQL Server with the default Arabic code page 1256. You can view the default sort order and code page for your SQL Server by opening a connection in Query Analyzer and executing the stored procedure sp_helpsort
Generally, if you have an environment where you have different character sets including the Arabic character set, you should consider using Unicode data types, which do not require conversion. Even in this case, however, varying behavior may result if different sort orders are used.