Dear Sirs, I am writing a device application that connects to SQL 2005 srever (collation is Arabic_CI_AS on the server), it is working just fine, but when I tried the same application on aonther device that has a different collation it does not connect to the server because of the collation, when I change the collation (as a test) for the server and all used columns in the tables to Latin1_General_CI_AS it works. is there a solution for this problem without changing the collation to all database tables columns?
Are you using unicode data types if not use unicode... And also check the following article article... http://msdn.microsoft.com/en-us/library/aa902644(SQL.80).aspx
I am using unicode date types (nvarchar), but the collation of the column is <database default> which is Latin, but I do not want to change it.
Try this thread, http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42033 But, its always good to have all the servers running with same collation.