RE: Import/Export with data containing portuguese characters

From: Burak Koc <burak.koc_at_intertech.com.tr>
Date: Thu, 7 Sep 2000 09:34:53 +0300
Message-Id: <10611.116374@fatcity.com>

u can define like this
NLS_LANG=AMERICAN_TURKEY.WE8ISO8859P9
export NLS_LANG
yes u should do it for both users

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of ALEMU Abiy Sent: Thursday, September 07, 2000 9:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: Import/Export with data containing portuguese characters

How can you define the NLS_LANG parameter in the .profile file ? With the SETENV command ? (I'm in tcsh) ? Should I do that for both importing and exporting operations ?

-----Message d'origine-----
De: burak.koc_at_intertech.com.tr [mailto:burak.koc_at_intertech.com.tr] Date: mercredi 6 septembre 2000 16:34
À: Multiple recipients of list ORACLE-L
Objet: RE: Import/Export with data containing portuguese characters

The characterset of the database to be imported must be the same with the database that you export.
The most important point is the NLS_LANG parameter must be set correct in the .profile file of the OS user that you import.

riginal Message-----
Sent: Wednesday, September 06, 2000 12:05 PM To: Multiple recipients of list ORACLE-L

I have a database with data having characters (all accents in portuguese language). When I make an export and import it to another database, I lose all special characters like "ã" transformed into "?". Is there options of Import or Export to conserve these characters ?

Please Help !!!

@biy @lemu
abiy.alemu_at_criltelecom.com <mailto:abiy.alemu_at_criltelecom.com> Cril Telecom Software
France

--
Author: ALEMU Abiy
  INET: abiy.alemu_at_criltechnology.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

--
Author: Burak Koc
  INET: burak.koc_at_intertech.com.tr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Author: ALEMU Abiy
  INET: abiy.alemu_at_criltechnology.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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

Received on Thu Sep 07 2000 - 01:34:53 CDT