Collation question

• VT-176769

  Mr or Mrs. 500

  Points: 577

  More actions

  August 15, 2006 at 3:05 am

  #91684

  HI

  Our database contain a view as shown bellow

  CREATE VIEW dbo.YYYY

  AS

  SELECT     *

  FROM         ZZZZ.Part.dbo.XXXX XXX_1

  server collation on ZZZZ is set to SQL_Latin1_General_CP1_CI_AS. But ZZZZ.Part's collation is Latin1_General_CI_AS. All varchar columns in XXXX set to use datebase default,which is Latin1_General_CI_AS

  the view above is on another database on different mechine,whoes server collation and database collation are SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS

  When i run sp_help YYYY  its giving me the collation as

  SQL_Latin1_General_CP1_CI_AS

  Shouldn't it be same as table collation;Latin1_General_CI_AS

  because of this i am getting

  "Cannot resolve collation conflict for equal to operation" error

  Thanks

  Ba

   

   

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  August 16, 2006 at 3:01 am

  #655215

  Try using 'collate database_default'.

  CREATE VIEW dbo.YYYY

  AS

  SELECT *

  FROM ZZZZ.Part.dbo.XXXX XXX_1 collate database_default

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!