E-MSS: MS SQL Server Collation Setting for Unicode

(Doc ID 662573.1)

Last updated on JULY 04, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms