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

[Message index]

		Portuguese characters are not displayed properly after import By: srix5 on Fri, 08 February 2008 10:40
		Re: Portuguese characters are not displayed properly after import By: Michel Cadot on Fri, 08 February 2008 10:49
		Re: Portuguese characters are not displayed properly after import By: srix5 on Sat, 09 February 2008 04:34
		Re: Portuguese characters are not displayed properly after import By: Michel Cadot on Sat, 09 February 2008 09:15

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 10 12:48:22 CDT 2024