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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 2, '04 at 8:39p
activeJan 2, '04 at 8:39p
posts1
users1
websiteoracle.com

1 user in discussion

Jaysingh1_at_optonline.net: 1 post

People

Translate

site design / logo © 2022 Grokbase