i bought a windows dedicated server(2k3) with plesk 7 .. & plesk 7 always come with MSDE database with it .

I bought a news manager tool for my soccer website which must work with either MSDE OR MS SQL SERVER .. & i tried using it on this server .. it works well but not when i add arabic articles .. which is the main language for my soccer website .

so i found that the problem mainly lies in the collation type of the MSDE database .. it doesn't support arabic characters .

i wanna have a solution either which by anyhow gets me to have the collation type for the MSDE datase on my server to be arabic .

pm me here or contact me at :

lost_romance@hotmail.com

Thanks on advance ..

u can also contact me at : mn.hattab@gmail.com

Did you try switching your country to Arabic in the control panel? that's basically all you need. MSDE will automatically switch the change over to your selected country code.

Thanks!

Einnar

Language Settings
Every SQL Server must have a default language that it uses to handle items such as date formats and messages. This information is stored for each login to the server that is created. Although this is initially set during setup, it can be overridden at the server level in the Server Settings tab in the SQL Server Properties dialog box, as shown in Figure 16.


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp

Or you could try this query on this database.

EXEC sp_defaultlanguage 'Database-name-goes-here', 'Arabic'