Hi,

I've got a question about collation.

short question:
Is there any argument against setting the collation for local databases to be the same as my hosted databases and is there a way to set the default?

using latest MojoPortal ASP.NET v4 windows MS SQL 2008r2 Express

longer version of the question:

Collation is something I was blissfully unaware even existed until recently. I became aware of it when I started getting collation conflicts. In MojoPortal I get one if I go to the member list - it occurs if my local database has one collation and remote has another. The error I get is: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

To change the collation of a local database - now that I have SQL Server Management Studio installed & know how to get to that option - takes maybe a minute or two, although its an annoying waste of time. Getting a hosting provider to do it can take a few days. I vaguely recall reading there's not much impact in choosing one collation over another, so I plump for changing mine.

I'm treating it as if its really not important.
Anyone know if this is likely to cause me any problem in future?

And if anyone knows how I can set my default collation that would be really handy.

I've done a bit of digging on collation, and will do some more, but so far have not happened across a good resource for it.