My Oracle Support Banner

E1: UPG: HowTo - Change In SQL Server Collation For EnterpriseOne 9.0 and Upgrade Process (Doc ID 1271189.1)

Last updated on JUNE 06, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
Checked for relevance on May 15, 2013


In this case here, this customer is upgrading from EnterpriseOne 8.10 to 9.0 application release level, and using SQL/2008 for the database. They noticed that the collation sequence default has changed from (8.10) SQL_Latin1_General_CP1_CI_AS to (9.0) Latin1_General_CI_AS_WS.
Since the upgrade is an in-place process, they will be left with the Business Data and Control Tables on the old collation and the System and Central Objects on the new collation.


Is there any reason to attempt to migrate the converted data in Business Data and Control Tables to the new collation? If the recommended Oracle Upgrade Process uses the existing (previous) database, which is in the old collation and is not changed by the upgrade, then what is the recommended Oracle process to get the upgraded database into the new 9.0 collation, and why is that not mentioned in the upgrade guide.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.