Justin,Thanks for your reply. When the French characters are loaded properl I did set NLS_LANG=French
-----Original Message----- Justin Cave Sent: Friday, January 02, 2004 7:14 PM To: Multiple recipients of list ORACLE-L 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, [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sami 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).