OraFAQ Forum: Server Utilities » Not showing the exact language after import

Members

Help

Home

Home » RDBMS Server » Server Utilities » Not showing the exact language after import (Oracle 10g (10.2.0.1.0) ,Centos 5 (2.6.9-67.0.1))

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Not showing the exact language after import [message #411422]

Fri, 03 July 2009 08:26

farhadctgbd
Messages: 3
Registered: July 2009
Location: Bangladesh

Junior Member

I export a user table from Oracle 10g in windows.
The I tried to import it in Oracle 10g in Centos 5
But I could not see the language is used(BENGALI).
IT shows me (?????????)

During export my parameter settings where ,

NLS_NCHAR_CHARACTERSET='AL16UTF16'
NLS_CHARTERSET='UTF8'

I also kept same settings in Linux.

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
export client uses UTF8 character set (possible charset conversion

But I no result..

Can any one help me with this issue

Thanks in advance ..

Report message to a moderator

Re: Not showing the exact language after import [message #411426 is a reply to message #411422]

Fri, 03 July 2009 08:29

Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member

Quote:

import done in US7ASCII

Correctly set your NLS_LANG environment parameter.

Regards
Michel

Report message to a moderator

Re: Not showing the exact language after import [message #411469 is a reply to message #411426]

Sat, 04 July 2009 02:33

farhadctgbd
Messages: 3
Registered: July 2009
Location: Bangladesh

Junior Member

Michel Cadot wrote on Fri, 03 July 2009 19:29

Quote:

import done in US7ASCII

Correctly set your NLS_LANG environment parameter.

Regards
Michel

Where should I set the NLS_LANG parameter in Centos environment variable ??

or In Linux database to which I made import.

or in xampp webserver

Can you explain How NLS_Parameters work during export or import.

I am not good in oracle

Report message to a moderator

Re: Not showing the exact language after import [message #411471 is a reply to message #411469]

Sat, 04 July 2009 02:53

Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member

Quote:

Where should I set the NLS_LANG parameter

In the client session that exports AND in the one that imports.

Quote:

Can you explain How NLS_Parameters work during export or import.

NLS_LANG tells Oracle which characters set your client is using or supporting (among other things). Oracle translate from the character set of your database to your client character set during import (and the opposite during export).
So if your set a NLS_LANG with a character set that does not support Bengali character (like US7ASCII) they are translated to a "replacement character" (which seems to be '?' in your case).

Regards
Michel

Report message to a moderator

Re: Not showing the exact language after import [message #411473 is a reply to message #411469]

Sat, 04 July 2009 02:55

Mohammad Taj
Messages: 2410
Registered: September 2006
Location: Dubai, UAE

Senior Member

Where should I set the NLS_LANG parameter in Centos environment variable ??
on that server where you trying to import .

check the oracle doc for exact command.

Report message to a moderator

Re: Not showing the exact language after import [message #413702 is a reply to message #411422]

Fri, 17 July 2009 03:01

farhadctgbd
Messages: 3
Registered: July 2009
Location: Bangladesh

Junior Member

At previous server

First I set NLS_LANG=AMERICAN_AMERICA.UTF8 in XP by regedit
then I export it.

At new Server
I set my environment variable in Centos 5
NLS_LANG=AMERICAN_AMERICA.UTF8
then import it.

At centos it shows me

Export file created by EXPORT:V10.02.01 via conventional path
import done in UTF8 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)

But I am seeing the same ??? mark in my webclient.

I also tried the above procedure using
NLS_LANG=AMERICAN_AMERICA.AL32UTF8

But result is same.

I cannot find where the problem is ??

Report message to a moderator

Previous Topic:	Export using query
Next Topic:	how to handle null values in sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 8 22:38:03 CST 2009

Total time taken to generate the page: 0.20716 seconds

.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.