pavel
  •  pavel
  • 54.8% (Neutral)
  • YAF Forumling Topic Starter
2009-01-28T02:50:50Z
Having set different collation for my own database (Czech_CI_AS) and for tempdb (Latin1_General_CI_AS) on my hosting I'm getting "Cannot resolve the collation conflict" error.

Resolution to this problem is to add "COLLATE DATABASE_DEFAULT" to places, where comparison of tempdb-values and database-values is made. As far as I have noticed, only changes in "providers\procedures.sql" have to be made. See bellow:

    SELECT  m.UserName, m.LastActivity, p.*
    FROM    [hatnamonreikico].[yaf_prov_Membership] m, [hatnamonreikico].[yaf_prov_Profile] p, #PageIndexForUsers i
    WHERE   m.UserId = p.UserId AND p.UserId  COLLATE DATABASE_DEFAULT = i.UserId  COLLATE DATABASE_DEFAULT AND i.IndexId >= @PageLowerBound AND i.IndexId <= @PageUpperBound


HTH
Pavel
Pavel
Sponsor
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2009-01-28T15:49:01Z

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved