How to Check Character Set Information in Oracle GoldenGate

Let's look at the following content from an example replicat report file.  You can find the following outputs:

Version 12.1.2.1.1 19797716 OGGCORE_12.1.2.1.1_PLATFORMS_141030.1944
Linux, x64, 64bit (optimized), Informix_SDK410 on Oct 30 2014 23:15:54
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.

Then,  the report file provide detailed character set information.  Let's look at this with an example replicat report file.  You can find the following outputs:

2014-12-08 16:05:00  INFO    OGG-03059  Operating system character set identified as UTF-8.  
---> This is the OS character set. 
…

2014-12-08 16:05:00  INFO    OGG-03036  Database character set identified as UTF-8. Locale: en_US. 
---> This is the target database server character set. 
…
2014-12-08 16:05:00  INFO    OGG-03037  Session character set identified as UTF-8. 
---> This is the target database session character set. 
…
2014-12-08 16:05:00  INFO    OGG-03528  The source database character set, as determined from the table definition file, is UTF-8. 
---> This shows the source database character set defined in the defgen file. 
…
2014-12-08 16:05:00  INFO    OGG-03506  The source database character set, as determined from the trail file, is UTF-8.
---> This shows the source database character set defined in the trail file. 

In this case, because source and target are all in UTF-8 encoding. There should not be any character set conversion in Oracle GoldenGate. 

I discussed that there are four types of character sets related to Oracle GoldenGate processing:

• Operating System Character Set
• Terminal Character Set
• DB Character Set, DB N-Charset
• DB Client/Session Character Set

In this blog, let me show you how to find all the character set information, except the terminal character set information.