Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL*Loader to load mutiple languages from the single datafile

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



Lafort
Franois
modle
dmineur                    

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US