Re: SQL*Loader to load mutiple languages from the single

When the French characters are loaded properly, are you setting NLS_LANG to FRANCE_FRENCH.UTF8, or are you using a different character set?

Justin Cave

At 01:39 PM 1/2/2004, jaysingh1_at_optonline.net wrote:
>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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Justin Cave
  INET: jcave_at_cableone.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).