This content has been marked as final. Show 5 replies
The characterset of the database does not change the language used in your input data file. The character set of the datafile can be set up by using the NLS_LANG parameter or by specifying a SQL*Loader CHARACTERSET parameter. I suggest to move this question to the appropriate forum: Export/Import/SQL Loader & External Tables for closer topic alignment.
We are testing our new 220.127.116.11 database using Oracle Linux 6. ...
Pl note that currently only 18.104.22.168 is certified/supported in Linux 6 - http://docs.oracle.com/cd/E11882_01/relnotes.112/e23558/toc.htm#CHDFHIEA - 22.214.171.124 is not - so things may or may not work as advertised.
What is the locale setting in Unix ?
The correct NLS_LANG setting in Unix Environments [ID 264157.1]
## we can see the correct characters in the file we are trying to load on the Linux server
How do you look at them? Do you see both Chinese and Russian correctly in a single file? Note, Russian is (partially) supported by Chinese character sets so the fact that you see both languages at once in a file does not necessarily mean that the file is encoded in UTF-8.