OraFAQ Forum: Portuguese » Portuguese characters are not importing properly.

Home » Non-English Forums » Portuguese » Portuguese characters are not importing properly.

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

Portuguese characters are not importing properly. [message #304580]

Wed, 05 March 2008 13:15

srix5
Messages: 11
Registered: March 2005
Location: Bangalore

Junior Member

Hi All,

I have a dump which was extracted from Oracle 8i db which is using the following characterset

NLS_CHARACTERSET - WE8PC850,
NLS_NCHAR_CHARACTERSET - US7ASCII

8i DB is running in HP box.

There are some values in PORTUGUESE language in some tables which is in the dump.

I imported the dump in 10g ( OS SOLARIS SPARC 10 ). My characterset is

NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16

After importing, i saw portuguese values are displayed like ?

I am 9i ( 9.2.0.1 ) client with 10g.

Can anyone help in which characterset i have to use in my db or what i have to do to import the portuguese values properly.

- SK.

Report message to a moderator

[Message index]

		Portuguese characters are not importing properly. By: srix5 on Wed, 05 March 2008 13:15
		Re: Portuguese characters are not importing properly. By: mkbhati on Wed, 05 March 2008 23:28

Previous Topic:	Portuguese characters are not displayed properly after import
Next Topic:	crash dump file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 03:11:43 CDT 2024