E-MSS: Is It Required that an Environment be on a Supported SQL Server Collation Before Performing an Upgrade?
(Doc ID 2439243.1)
Last updated on DECEMBER 03, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.
For upgrading Campus solutions 9.0/8.55 to 9.2/8.56, the upgrade Source Demo was created using the Upgrade Source Image Installation method and the default collation Latin1_General_Bin was selected (based on the doc PeopleSoft 9.2 Application Installationfor Microsoft SQL Server (PeopleSoft PeopleTools 8.56)). The production environment is on a different collation (Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data). Please address the below questions
- Is is required that the source and target to be on same collation?
- If it is, should the Copy of Production collation be changed before the upgrade?
- How will the change impact the upgrade process?
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