Different database & server collation
Home > IT Answers > SQL Server > Different database & server collation
Db23
230 pts.
0
Q:
Different database & server collation
SQL Server 2005, Collation
Hi,


We have a database that is sitting on a SQL Server 2005 with different collation setting, the application connect to the database is running with out any issue. Have anyone had this same issue, if so how long has your application run with different database and server collation without running into collation issue?

Thanks
ASKED: Oct 14 2009  5:26 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46735 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
As long as you aren't running queries that join tables between databases you can have a database in a different collation for ever. It doesn't effect the length of time the database can be hosed on that instance. You could have each user database on the server have a different collation if you wanted to.
Last Answered: Oct 16 2009  4:28 AM GMT by Mrdenny   46735 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Db23   230 pts.  |   Oct 17 2009  5:15AM GMT

Thanks for clearing this up, have you had any application connecting to a production databases with different collation than the SQL Server 2005 instance? If so how common is this and how has it been running?

 

mrdenny   46735 pts.  |   Oct 19 2009  6:32PM GMT

Yes, a company I worked for a couple of years ago was setup like this. I’m not sure how common it is. Some applications require a specific collation for one reason or another. Overall I would say that it’s probably not that common outside of a large hosting provider.

 
0