SQL*Loader to load mutiple languages from the single datafile

From: <jaysingh1_at_optonline.net>
Date: Fri, 02 Jan 2004 12:39:24 -0800
Message-ID: <F001.005DB853.20040102123924@fatcity.com>

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: jaysingh1_at_optonline.net

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: ListGuru_at_fatcity.com (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).

Received on Fri Jan 02 2004 - 14:39:24 CST