My Oracle Support Banner

Changing the DB Characterset to facilitate Data loading from Source files (Doc ID 2721462.1)

Last updated on OCTOBER 23, 2020

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Goal

To provide insight on changing the database CHARACTERSET value for loading data from file to table and its impact in FCCM BD product and applications.

E.g.

ETL team is receiving some special character from source file which has different CHARACTERSET format. But, by default CHARACTERSET was set for all DB environment as AL32UTF8.The special character which was coming from source having CHARACTERSET as WE8ISO8859P1. Can data be loaded with special character in DB level or table level if the CHARACTERSET value is changed.

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


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