SQL Server Collation Issues - Article

  • Thread starter brother_of_karamazov
  • Start date

brother_of_karamazov

Legendary Poster
"Starting in EnterpriseOne 9.0 the platform pack delivers pre-built databases that are simply attached and are set to a collation of Latin1_General_CI_AS_WS. This collation is different than the default SQL Server collation and different than the old (pre-9.0) collations. Because of this, you will usually find a mix of collations on an E1 install, particularly upgrades. The collation for E1 databases will likely be different than the collation for tempdb and master. This can cause problems in an EnterpriseOne system and could result in "Cannot resolve collation conflict" or "Cannot resolve the collation conflict" errors appearing in logs during upgrades or JOIN operations."


http://jeffstevenson.karamazovgroup.com/2011/08/enterpriseone-90-sql-server-collation.html
 
Back
Top