Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Location
    Brazil
    Posts
    56

    Unanswered: Cannot resolve collation conflict for equal to operation.

    Hy Guys!

    I`m having a new problem today!
    I Have two Databases, with the same collation configuration. (SQL_Latin1_General_CP1_CI_AS). But when I execute this qery, I got the collation message error:


    select * from Cheque C
    where
    NOT EXISTS
    (SELECT A.cmpCod + A.banCod
    FROM dbCorporativo.dbo.Agencia A
    WHERE
    C.chqCmc7Compe + C.chqCmc7Bco
    =
    A.cmpCod + A.banCod
    )

    Result
    Cannot resolve collation conflict for equal to operation.


    This query executes with succes when I execute it like this:
    select * from Cheque C
    where
    NOT EXISTS
    (SELECT A.cmpCod + A.banCod
    FROM dbCorporativo.dbo.Agencia A
    WHERE
    C.chqCmc7Compe + C.chqCmc7Bco
    =
    A.cmpCod + A.banCod COLLATE SQL_Latin1_General_CP1_CI_AS
    )



    Some suggestions? Since the configuration for the two databases are identical?
    Diogo Hudson Dias
    DBA - SQL 6.5/7.0/2000
    ASBACE - ATP

  2. #2
    Join Date
    Sep 2002
    Location
    Brazil
    Posts
    56
    Ooopppss!! WRONG FORUM!

    Sorry guys!
    Diogo Hudson Dias
    DBA - SQL 6.5/7.0/2000
    ASBACE - ATP

  3. #3
    Join Date
    Mar 2003
    Location
    Melbourne, Australia
    Posts
    6
    Diogo,

    The model database must have different collation settings, temp databases / tables obtain/inherit the model database settings. When you specify a collation it sets the collation and thus there are no problems.

Posting Permissions

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