How do I make my MSSQL Server 2000 Database supports Arabic Language?

First: make sure that your data types of your database fields are (nchar, nvarchar, and ntext). Second: Remember that the use of the "n" prefix to represent Unicode data in both string literals and data types. SQL Select Statement example: SELECT * FROM MyTable WHERE Myfield = N' "& Searching_Criteria &" ' ; " SQL Insert Statement example: INSERT INTO MyTable (Myfield ) VALUES ( N' "& My_Value &" ') SQL Update Statement example: UPDATE MyTable Set Myfield = N' "& My_Value &" ' For more information about Multilingual Transact-SQL please read the following MSDN article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp