SQL*Loader to load mutiple languages from the single datafile

[jaysingh1]

Dear All,

Happy New Year!

I have to load both French and Japanese characters from the same datafile into tables 
using SQL*loader.

DB character set is UTF8 (version 8.1.7.3)
Client : Unix (Sun Solaris)

If I set NLS_LANG=AMERICAN_AMERICA.UTF8 then French characters are NOT getting 
loaded properly(garbled-> non-readable format) but Japanese characters are 
getting loaded without any problem.

If I set NLS_LANG=French then French characters are  getting loaded properly( no 
garbled issue) but Japanese characters are NOT getting loaded(garbled).

French Data
===========
Laforêt
François
modèle
démineur    
                   
Japanase Data
===============
絞り込�履歴
絞り込��設定

I copied sample FRENCH & JAPANESE characters above.
Even here in BROWSER, 
(A)if the BROWSER Encoding (please select View->Encoding) is set to 
Unicode(UTF-8)then Japanese Data (characters) are in READABLE format.

(B)if the BROWSER Encoding (please select View->Encoding) is set to Wester 
European(ISO),then French Data (characters) are in READABLE format.

Questions:
==========
1)Why french characters are not getting loaded properly when I set 
NLS_LANG=AMERICAN_AMEICA.UTF8

2)How do I load mutiple langauges content from the same datafile into db table.

Kindly through some light on this?  

Thanks for your time.
Jay

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).