No, the default is US7ASCII. See table 3-2 at
http://docs.oracle.com/cd_a97630/server.920/a96529/ch3.htm#56354. That's
why you're losing the extended characters.
Gary
-----Original Message-----
Sent: Tuesday, August 27, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L
See, this is why this stuff confuses me.. shouldn't UTF8 accept the
diacritical marks?
argh... in any case, it's working now
Rachel
- "SARKAR, Samir" <Samir.SARKAR_at_nottingham.sema.slb.com> wrote:
> Rachel,
>
> The Unix server generally looks for the character set
> AMERICAN_AMERICA.UTF8 unless you specify it explicitly otherwise by
> setting the environmental
> variable
> before the installation commences.
>
> Samir
>
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email : ssarkar2_at_slb.com
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
>
>
> -----Original Message-----
> Sent: 27 August 2002 16:48
> To: Multiple recipients of list ORACLE-L
>
>
> Ron,
>
> You were dead on correct (send me your snail mail address offlist and
> I'll send you a signed copy of Oracle9i DBA 101)
>
> Anjo, you were right too but you already have, or should be getting,
> a
> copy of the book. I'll buy you a beer at the next conference :)
>
> Very strange. I was loading ON the server itself, not from my client.
> Database is 9.2, my client on my PC is 8.1.7. The load worked from my
> PC but not from the server. The pertinent default NLS parameters,
> from
> NLS_DATABASE_PARAMETERS, when I do NOT set NLS_LANG are
>
> PARAMETER VALUE
> ------------------------------
> ----------------------------------------
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_CHARACTERSET WE8ISO8859P1
> NLS_NCHAR_CHARACTERSET AL16UTF16
> NLS_RDBMS_VERSION 9.2.0.1.0
>
> which looks right but the load doesn't work. When I set the Unix
> environment variable NLS_LANG to AMERICAN_AMERICA.WE8ISO8859P1, the
> load works properly. Anyone want to explain THAT to me?
>
> and the docs are, as usual, clear as mud. I figured it out with the
> hints from Ron and Anjo and testing inserts from my PC and the server
> directly.
>
> Hope this helps some other poor soul in the future!
>
> Rachel
>
> --- Ron Thomas <rthomas_at_hypercom.com> wrote:
> >
> > Make sure your environment NLS_LANG matches how the data is encoded
> > in your flat file.
> >
> > Also, does the database characterset handle whatever special
> > characters you are trying to import?
> >
> > Ron Thomas
> > Hypercom, Inc
> > rthomas_at_hypercom.com
> > If A = B and B = C, then A = C, except where void or prohibited by
> > law. -- Roy Santoro
> >
> >
> >
>
> >
> > root_at_fatcity.com
>
> >
> > To:
> > ORACLE-L_at_fatcity.com
>
> >
> > 08/26/02 02:41 PM cc:
>
> >
> > Please respond to Subject: sql loader
> > control file help
> > ORACLE-L
>
> >
> >
>
> >
> >
>
> >
> >
> >
> >
> >
> > I am not, by any means, a SQL*Loader expert (Jonathan, I keep
> meaning
> > to get your book!)
> >
> > Here's the thing:
> >
> > I have a flat file with character data that includes special
> > characters
> > (like accents and diacritical marks over letters). When I load the
> > data
> > in using SQL*Loader, the special characters disappear and are
> > replaced
> > by the letter (so Dvorák goes on as Dvorak).
> >
> > How can I get the data in as it should be? I've been reading and
> will
> > continue to read the fine manual, but I'm not finding this...
> >
> > Help!
> >
> > Rachel
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Finance - Get real-time stock quotes
> > http://finance.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.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).
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ron Thomas
> > INET: rthomas_at_hypercom.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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.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).
>
>
> _________________________________________________________
> This email is confidential and intended solely for the use of the
> individual to whom it is addressed. Any views or opinions presented
> are
> solely those of the author and do not necessarily represent those of
> SchlumbergerSema.
> If you are not the intended recipient, be advised that you have
> received
> this email in error and that any use, dissemination, forwarding,
> printing, or copying of this email is strictly prohibited.
>
=== message truncated ===
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kirsh, Gary
INET: gary.kirsh_at_gs.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).
Received on Tue Aug 27 2002 - 17:13:26 CDT
