Which Character Set Should be Used for OFSA With Oracle 9.2.0.6? (Doc ID 344543.1)

Last updated on JULY 10, 2009

Applies to:

Oracle Financial Services Applications (OFSA) - Version: 4.5
Oracle Financial Data Manager - Version: 4.5
Information in this document applies to any platform.

Goal

Currently upgrading from 8.1.7 to 9.2.0.6. Which character set and national character set should be used on the 9.2.0.6 create database statement?

8.1.7.2 settings:

SQL+ > select * from NLS_DATABASE_PARAMETERS;
PARAMETER VALUE
------------------------------
NLS_NCHAR_CHARACTERSET US7ASCII
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_DATE_FORMAT MM/DD/YYYY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET US7ASCII

Solution

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