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 126.96.36.199 database using Oracle Linux 6. ...
Pl note that currently only 188.8.131.52 is certified/supported in Linux 6 - http://docs.oracle.com/cd/E11882_01/relnotes.112/e23558/toc.htm#CHDFHIEA - 184.108.40.206 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.