Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Collation on SQL Server 2008

    I have database which I am testing on sql server 2008 as installed by a.n.other.
    the server is a shared area so I am pretty much tied to the set up already chosen by the installer.

    When I have created and restored the database I am seeing an error relating to collation:
    Cannot resolve the collation conflict between
    "SQL_Latin1_General_CP1_Cl_AS" and "Latin1_General_Cl_AS" in the equal to operation.
    The database is a third parties which we have no 'intimate' control over (i.e. all processes are stock) so I would not be able to rewrite any of the procedures.
    I have searched the collation process and everyone seems to be recommending either rewriting the queries (not possible, see above) or re-installing SQL2008 with alternative options for languages.

    Has anyone come across this previously and have a straight forward solution?
    thanks
    Alan

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    You can find the collations supported on your server by running this in Management Studio

    Code:
    SELECT * from ::fn_helpcollations()
    You can, of course, change the problematic columns to the collation needed to avoid those issues. This can be done through ALTER TABLE statements.
    Last edited by ruirib; 2011-10-15 at 05:28.

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,203
    Thanks
    49
    Thanked 989 Times in 919 Posts
    If the database relies on the collation for results - which is bad practice - you will need to install another instance of SQL with the correct collation. Multiple instances on the same server are supported in Windows.

    cheers, Paul

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    thanks

    Thanks Guys, just trawling through the database now to check and correct.
    Didn't help that the 2008SM was installed blindly with nothing checked.
    Thanks again.
    alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •