OraFAQ Forum: Server Utilities » Encoding Issue on Oracle9i

Home » RDBMS Server » Server Utilities » Encoding Issue on Oracle9i (Invalid characters displayed when data loaded via SQL Ldr)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Encoding Issue on Oracle9i [message #274061]

Sat, 13 October 2007 05:20

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

Report message to a moderator

Re: Encoding Issue on Oracle9i [message #274063 is a reply to message #274061]

Sat, 13 October 2007 05:42

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Encoding Issue on Oracle9i [message #274065 is a reply to message #274061]

Sat, 13 October 2007 05:50

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..

Report message to a moderator

Re: Encoding Issue on Oracle9i [message #274068 is a reply to message #274065]

Sat, 13 October 2007 06:04

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try to use CHARACTERSET WE8ISO8859P1 in control file.

Regards
Michel

Report message to a moderator

Re: Encoding Issue on Oracle9i [message #274069 is a reply to message #274068]

Sat, 13 October 2007 06:08

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..

Report message to a moderator

Re: Encoding Issue on Oracle9i [message #274076 is a reply to message #274069]

Sat, 13 October 2007 08:26

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Encoding Issue on Oracle9i [message #274699 is a reply to message #274061]

Tue, 16 October 2007 20:00

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 02:54:21 CST 2025