SQL Server Performance

Device Application problem with collation

Discussion in 'SQL Server 2005 General Developer Questions' started by tarekj, Nov 19, 2009.

  1. tarekj Member

    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?
  2. MohammedU New Member

  3. tarekj Member

    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.
  4. balaganapathy.n New Member

    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.

Share This Page