| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQLLoader
You use the CHARACTERSET keyword to specify to SQL*Loader which
character set is used in each datafile. Different datafiles can be
specified with different character sets. However, only one character set
can be specified for each datafile.
Using the CHARACTERSET keyword causes character data to be automatically converted when it is loaded into the database. Only CHAR, DATE, and numeric EXTERNAL fields are affected. If the CHARACTERSET keyword is not specified, then no conversion occurs.
The CHARACTERSET syntax is:
CHARACTERSET character_set_spec
where character_set_spec is the acronym used by Oracle to refer to your particular encoding scheme.
Note: The characterset specified does not apply to data in the control file
LOAD DATA
CHARACTERSET char_set_name
....
-----Original Message-----
Sent: Friday, July 19, 2002 1:23 PM
To: ORACLE-L
Cc: Antje.Sackwitz
Hi,
I have to load an ASCII dump into Oracle with loader that contains date
information in a different national character set than my databse.
Can I specify a different nls_lang ( Do an alter session set =
nls_lang...)
before the load?
If so, can you please give me the syntax?
Regards,
Antje Sackwitz
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sackwitz, Antje
INET: Antje.Sackwitz_at_ppi.de
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: cosltemp-g.manoj_at_orbitech.co.in
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). Received on Fri Jul 19 2002 - 03:58:18 CDT
 |
 |