InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumMon, 18 May 2026 10:07:08 GMT20http://forum.strataframe.net/FindPost21117.aspxI have a project that integrates with software whose backend is on SQL Server 2000 and where the database default collation type is Latin1_General_BIN. I created a new database with the standard collation type of SQL_Latin1_General_CP1_CI_AS. When I try to join tables across database with a foreign key in my database I get an error like "Cannot resolve the collation conflict between "Latin1_General_BIN" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."<br> <br> I figured out that I can change the collation type for columns in the database to avoid this problem. Unfortunately DDT doesn't apply this setting when deploying a DDT package. <br> <br> Any chance you could add the ability for DDT store this setting and apply it when deploying to a new database?<br> <br> Thanks,<br> GovindaWed, 10 Dec 2008 16:18:18 GMTGovinda Berrio