My Oracle Support Banner

E-MSS: MS SQL Server Collation Setting for Unicode (Doc ID 662573.1)

Last updated on DECEMBER 05, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.2 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201070625



"""""reviewed for currency Feb 2010"""""
***Checked for relevance on 30-Mar-2012***
***Checked for relevance on 13-Sep-2013***

Symptoms

ISSUE:
In the process of installing a PeopleSoft environment (Unicode) with multi-language support: Korean, Chinese, Japanese, English and other European language.

According to the PeopleTools Installation guide, we need to select Latin1_General_Bin for collation and Binary Sort for the SQL server installation. What SQL server collation setting should be selected for the Unicode database that will support Korean, Japanese, Chinese, English, and multiple European languages?

Cause

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
Symptoms
Cause
Solution

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