Linux is UTF8, NLS_LANG is AL32UTF8 but shell script file contains § char and is P1
With Linux Node running with locale en_US.UTF-8, therefore our NLS_LANG env variable is set to AL32UTF8.
However, the job scheduling system is transferring a shell script file to the Linux database node, which contains special characters like "§". The paragraph sign in this file is Hex A7, not unicode "C2A7".
With NLS_LANG AL32UTF8, this sign is not inserted correctly into the database. If changing NLS_LANG in this script to P1, then it is correctly inserted.
This is part of the content from the shell script:
[td0crmkk@serv3872 ~]$ hexdump -C uc4.txt
00000000 69 6e 73 65 72 74 20 69 6e 74 6f 20 61 64 6d 64 |insert into admd|
However, the job scheduling system is transferring a shell script file to the Linux database node, which contains special characters like "§". The paragraph sign in this file is Hex A7, not unicode "C2A7".
With NLS_LANG AL32UTF8, this sign is not inserted correctly into the database. If changing NLS_LANG in this script to P1, then it is correctly inserted.
This is part of the content from the shell script:
[td0crmkk@serv3872 ~]$ hexdump -C uc4.txt
00000000 69 6e 73 65 72 74 20 69 6e 74 6f 20 61 64 6d 64 |insert into admd|
0