OraFAQ Forum: Portuguese » Portuguese characters are not displayed properly after import

Home » Non-English Forums » Portuguese » Portuguese characters are not displayed properly after import

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

Portuguese characters are not displayed properly after import [message #299015]

Fri, 08 February 2008 10:40

srix5
Messages: 11
Registered: March 2005
Location: Bangalore

Junior Member

Hi All,

I have a oracle 7 db in HP unix box, which has portuguese characters in some tables.

Character sets as follows,

9i
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16

I tried to export from 7 and import to 10g which is in Solaris 10. After importing portuguese characters are not displayed properly in Toad or in sqlplus. 10g also has the same characterset.

10g
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16

I set NLS_LANG in the following way in both the machines .profile's before export and import,

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1;export NLS_LANG

Am i missing some other things...?

- SK.

Report message to a moderator

Re: Portuguese characters are not displayed properly after import [message #299018 is a reply to message #299015]

Fri, 08 February 2008 10:49

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

Senior Member
Account Moderator

1/ Does WE8ISO8859P1 contains/supports portuguese characters?
2/ Does your Windows a portuguese one?
3/ Does your Oracle NLS_LANG on Windows set to portuguese characters?
4/ If you spool the result in a file and open it with wordpad, do you see portuguese characters?
5/ What is the result on your server side?

Regards
Michel

[Updated on: Fri, 08 February 2008 10:50]

Report message to a moderator

Re: Portuguese characters are not displayed properly after import [message #299095 is a reply to message #299018]

Sat, 09 February 2008 04:34

srix5
Messages: 11
Registered: March 2005
Location: Bangalore

Junior Member

Hi Michel,

Thankyou very much for your reply.

My current database characterset ( Oracle 7 Version ) has the following characterset,
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16

Application is displaying the portuguese characters properly. But when i spool the output and open it in wordpad it is showing only junk characters other than portuguese characters.

My windows is not a portuguese one.

My windows NLS_LANG was set to AMERICAN_AMERICA.WE8ISO8859P1

Server side also it is not displaying the characters properly. To view this properly, first i will prepare a .csv and converting this in excel through get external data option and selecting File Origin as MS-DOS (PC-8). After doing this, i am able to view portuguese character in Excel.

Thankyou again.

- SK.

Report message to a moderator

Re: Portuguese characters are not displayed properly after import [message #299114 is a reply to message #299095]

Sat, 09 February 2008 09:15

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

Senior Member
Account Moderator

This means that your original client application was using PC-8 character set but had its NLS_LANG set to WE8ISO8859P1.
As long as you use the same application with the same wrong setting there is no problem but as soon as you set the correct NLS_LANG parameter then problem appears.

You have to unload the whole data in a PC-8 client but setting NLS_LANG to 8859P1, then change NLS_LANG to the correct setting and reload the database.

Regards
Michel

Report message to a moderator

Previous Topic:	Problem storing text on a BLOB column if language is Portuguese
Next Topic:	Portuguese characters are not importing properly.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 01:31:11 CDT 2025