Re: sql loader control file help
On Mon, 26 Aug 2002 13:41:50 -0800, Rachel wrote: I am not, by any means, a SQL*Loader expert (Jonathan, I keep meaning to get your book!) Sounds like you've solved this one already, but since you invoked my name (and in vain too, since I was of no help grin), I'll just chime in to say that my best guess is that you are encountering a character set translation issue. Not sure my book would help much with this. I don't recall delving into character sets in the book. I'll have to correct that omission when I do the revision. I will say that I've recently had occasion to delve into Oracle's support of Unicode (for Steven Feuerstein's upcomming PL/SQL, Third Edition). It's incredible how complicated something so seemingly simple (on the surface) can be. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] 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: [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).
Re: sql loader control file help
I find that the worst problems I have with SQL*Loader tend to be language related. The same goes with export/import. I wish there were better documentation on the NLS parameters. and yes, it was characterset. What I didn't understand was why when I selected from NLS_DATABASE_PARAMETERS it showed the proper settings yet I couldn't load. NLS_LANG was unset in Unix/ one of these days I might actually learn something about Oracle :) --- Jonathan Gennick [EMAIL PROTECTED] wrote: On Mon, 26 Aug 2002 13:41:50 -0800, Rachel wrote: I am not, by any means, a SQL*Loader expert (Jonathan, I keep meaning to get your book!) Sounds like you've solved this one already, but since you invoked my name (and in vain too, since I was of no help grin), I'll just chime in to say that my best guess is that you are encountering a character set translation issue. Not sure my book would help much with this. I don't recall delving into character sets in the book. I'll have to correct that omission when I do the revision. I will say that I've recently had occasion to delve into Oracle's support of Unicode (for Steven Feuerstein's upcomming PL/SQL, Third Edition). It's incredible how complicated something so seemingly simple (on the surface) can be. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] 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: [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). __ 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: [EMAIL PROTECTED] 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: [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).
Re[2]:RE: sql loader control file help - solved
Rachel, Then why did you not put it that way in the first place? Damn I hate those $1,000,000,000 words that I don't understand. Dick Goulet :-) Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/27/2002 5:58 PM accents over letters (Dvorak instead of Dvorák as it should be) etc --- [EMAIL PROTECTED] wrote: What marks? Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/27/2002 1:13 PM 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 [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 __ 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: [EMAIL PROTECTED] 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: [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.com -- Author: INET: [EMAIL PROTECTED] 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: [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).
Re: Re[2]:RE: sql loader control file help - solved
Dick, But I DID put it that way originally... in my initial email. Which was at the bottom of yours :) Besides, my goal is to make programmers who speak English actually learn to use the language EG Rachel --- [EMAIL PROTECTED] wrote: Rachel, Then why did you not put it that way in the first place? Damn I hate those $1,000,000,000 words that I don't understand. Dick Goulet :-) Reply Separator Subject:Re:RE: sql loader control file help - solved Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/27/2002 5:58 PM accents over letters (Dvorak instead of Dvorák as it should be) etc --- [EMAIL PROTECTED] wrote: What marks? Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/27/2002 1:13 PM 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 [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 __ 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: [EMAIL PROTECTED] 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: [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). __ 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: [EMAIL PROTECTED] 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: [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).
Re: sql loader control file help - solved
gee, this is so cool. The authors I used to read in flesh and blood, and actually giving away a signed copy! I'm gonna make sure I drop everything and answer the next query Rachel puts. (And then pray hard its right and I get a copy too!) With Warm Regards, Manav. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 9:18 PM 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: 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: [EMAIL PROTECTED] 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: [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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] 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: [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). __ 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: [EMAIL PROTECTED] 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: [EMAIL
Re: sql loader control file help - solved
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: 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: [EMAIL PROTECTED] 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: [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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] 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: [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). __ 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: [EMAIL PROTECTED] Fat City
RE: sql loader control file help - solved
Rachel, I think that you are seeing this behavior, because when on Unix, if NLS_LANG is not set in the environment, it defaults to US7ASCII, which does not include the extended characters. The characterset shown in NLS_DATABASE_PARAMETERS is the database's characterset, not the charset which the client picks up from the environment: 1* select * from NLS_DATABASE_PARAMETERS PARAMETER VALUE -- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8ISO8859P1 NLS_CALENDAR GREGORIAN NLS_DATE_FORMATDD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMATHH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZH:TZM NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_NCHAR_CHARACTERSET WE8ISO8859P1 NLS_RDBMS_VERSION 8.1.7.3.0 18 rows selected. SAMTESTN !echo $NLS_LANG AMERICAN_AMERICA.US7ASCII On Windows, however, I think the default is WE8ISO8859P1. HTH Gary Gary Kirsh Next Extent Consulting -Original Message- Sent: Tuesday, August 27, 2002 11:48 AM 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: sql loader control file help ORACLE-L
RE: sql loader control file help - solved
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 : [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: 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: [EMAIL PROTECTED] 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: [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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT
RE: sql loader control file help - solved
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 [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: 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: [EMAIL PROTECTED] 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: [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.com -- Author: Ron Thomas INET
Re: sql loader control file help
Rachel, If you did not solve it allreddy set your unix environment variable NLS_LANG. This should eliminate your loading problem. Hope this helps Shaibal From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: sql loader control file help Date: Mon, 26 Aug 2002 13:41:51 -0800 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: [EMAIL PROTECTED] 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: [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). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] 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: [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).
Re:RE: sql loader control file help - solved
What marks? Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/27/2002 1:13 PM 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 [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: 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: [EMAIL PROTECTED] 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: [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
RE: sql loader control file help - solved
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 [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Re:RE: sql loader control file help - solved
accents over letters (Dvorak instead of Dvorák as it should be) etc --- [EMAIL PROTECTED] wrote: What marks? Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/27/2002 1:13 PM 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 [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 __ 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: [EMAIL PROTECTED] 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: [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).
sql loader control file help
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: [EMAIL PROTECTED] 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: [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).
Re: sql loader control file help
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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: 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: [EMAIL PROTECTED] 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: [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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] 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: [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).
Re: sql loader control file help
I don't think NLS_LANG is set at all, or if it is, it's the default value. The database DOES handle the characterset, when we 'cause when we try put the data in via an insert statement, it goes in correctly. I forgot (sigh) more info: 9.2 db, Solaris I am running the load ON the server, not via a client install. Rachel --- Ron Thomas [EMAIL PROTECTED] 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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: 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: [EMAIL PROTECTED] 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: [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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] 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: [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). __ 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: [EMAIL PROTECTED] 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: [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).
Re: sql loader control file help
I don't think NLS_LANG is set at all, or if it is, it's the default value. The database DOES handle the characterset, when we 'cause when we try put the data in via an insert statement, it goes in correctly. I forgot (sigh) more info: 9.2 db, Solaris I am running the load ON the server, not via a client install. Rachel --- Ron Thomas [EMAIL PROTECTED] 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 [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: 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: [EMAIL PROTECTED] 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: [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.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] 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: [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). __ 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: [EMAIL PROTECTED] 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: [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).