Home » RDBMS Server » Server Utilities » Encoding Issue on Oracle9i (Invalid characters displayed when data loaded via SQL Ldr)
Encoding Issue on Oracle9i [message #274061] Sat, 13 October 2007 05:20 Go to next message
b_pereira
Messages: 4
Registered: October 2007
Junior Member
Hi,

I am trying to load a few CSV files into Oracle using the sqlldr - The files are encoded using ISO-8859-1 - The database character set is also set to Western European ISO-8859-1, However, once imported some of the characters appear as inverted question marks - the characters are the plus minus character and the super script 2 - Both these character are supported by the ISO-8859-1 - Any idea why this is happening and what's the workaround? - Also the same imported on a Windows machine using UTF-8 as the characterset works fine

I have the NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1

Thanks in advance

Re: Encoding Issue on Oracle9i [message #274063 is a reply to message #274061] Sat, 13 October 2007 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Any idea why this is happening

If all what you posted is true, then it is not possible.

Regards
Michel
Re: Encoding Issue on Oracle9i [message #274065 is a reply to message #274061] Sat, 13 October 2007 05:50 Go to previous messageGo to next message
b_pereira
Messages: 4
Registered: October 2007
Junior Member
Yes all that is posted is true - Another thing that i noticed is that running a dump on the particular column to get the actual values stored in the database corresponds directly to the Ascii codes - I even tried setting the characterset to US7ASCII in the .ctl file but no luck - Is it possible that the SQL loader is treating the datafile as ASCII and importing it exactly as is??

Thanks..
Re: Encoding Issue on Oracle9i [message #274068 is a reply to message #274065] Sat, 13 October 2007 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try to use CHARACTERSET WE8ISO8859P1 in control file.

Regards
Michel
Re: Encoding Issue on Oracle9i [message #274069 is a reply to message #274068] Sat, 13 October 2007 06:08 Go to previous messageGo to next message
b_pereira
Messages: 4
Registered: October 2007
Junior Member
I'll try that but according to the Sqlldr documentation specifying a characterset in the .ctl file tells the loader the characterset of the datafile and it can then convert the same to the database characterset - Correct me if i'm wrong

Thanks..
Re: Encoding Issue on Oracle9i [message #274076 is a reply to message #274069] Sat, 13 October 2007 08:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are correct but as what you posted is not possible, I try to find something.
Now post a test case we can reproduce that is create table statement, the control file, and some data to load.

Regards
Michel
Re: Encoding Issue on Oracle9i [message #274699 is a reply to message #274061] Tue, 16 October 2007 20:00 Go to previous message
b_pereira
Messages: 4
Registered: October 2007
Junior Member
Thanks Guys,

I figured out the issues - It had to do with the setting of NLS_LANG

Regards
Previous Topic: need to load data from different sheets of the same xl file
Next Topic: sqlldr (merged)
Goto Forum:
  


Current Time: Wed Dec 07 14:26:45 CST 2016

Total time taken to generate the page: 0.23115 seconds