August 10, 2010 at 12:20 pm
Hi,
I have an instance of SQL Server 2005 installed on a server. The collation is set to SQL_Latin_General_CP1_Cl_AS. If I install SQL Server on my machine and connect to the instance on the server; is the collation setting on my machine important. For example, if I have my collation set different than what the server is, then will this cause issues ?
Thanks.
August 10, 2010 at 1:39 pm
Generally no, but it does depend what you're doing. Any queries across the two servers that involves joins on string values would have to have a COLLATE clause added to them to specify the collation to be used. You should also remember that a case-sensitive collation will allow what a case-insensitive collation would consider duplicates in a character-based primary key or unique index (e.g. 'STRING' would not equal 'string' on CS but would on CI) if you intend to transfer data between the two.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply