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

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

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

From: Justin Cave <jcave_at_cableone.net>
Date: Fri, 02 Jan 2004 16:14:25 -0800
Message-ID: <F001.005DB858.20040102161425@fatcity.com>


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
>===========
>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).

-- 
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).
Received on Fri Jan 02 2004 - 18:14:25 CST

Original text of this message

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