My Oracle Support Banner

E1: UPG: INST: DB: Overview Of SQL Server Collation (Latin1_General_CI_AS_WS vs. Latin1_General_CI_AS) (Doc ID 1267442.1)

Last updated on FEBRUARY 04, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.





Goal

This document is an overview of SQL Server Collation, in particular the pros and cons of Latin1_General_CI_AS_WS collation in relation to Latin1_General_CI_AS and how the Platform Pack for EnterpriseOne 9.0 and above install is affected.  This document is valid for customers doing a new installation of EnterpriseOne software or for customers doing an upgrade of EnterpriseOne to a higher application release level.

Solution

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
Goal
Solution
 --- Questions and Answers ---
 What is SQL Server Collation? 
 We are in the process of E1 9.0 installation on a Windows 2008 64bit and SQLServer2008 64bit.  For the SQL Server, does JDE support 'SQLServer Collation: Latin1_General_C1_As'?
 The SQL Server installation is completed with Latin1_General_CI_AS collation, however the JDE Platform Pack installation created the standard databases with Latin1_General_CI_AS_WS collation. Will this be ok?
 In order to avoid any TEMPDB issue, does the SQL Server need to be installed with Latin1_General_CI_AS_WS?
 Custom SQL Statements
References

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