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))
icon4.gif  Not showing the exact language after import [message #411422] Fri, 03 July 2009 08:26 Go to next message
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 ..

Re: Not showing the exact language after import [message #411426 is a reply to message #411422] Fri, 03 July 2009 08:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
import done in US7ASCII

Correctly set your NLS_LANG environment parameter.

Regards
Michel
Re: Not showing the exact language after import [message #411469 is a reply to message #411426] Sat, 04 July 2009 02:33 Go to previous messageGo to next message
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



Re: Not showing the exact language after import [message #411471 is a reply to message #411469] Sat, 04 July 2009 02:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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

Re: Not showing the exact language after import [message #411473 is a reply to message #411469] Sat, 04 July 2009 02:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
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.
Re: Not showing the exact language after import [message #413702 is a reply to message #411422] Fri, 17 July 2009 03:01 Go to previous message
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 ??


Previous Topic: Export using query
Next Topic: Import data error
Goto Forum:
  


Current Time: Sun Dec 11 08:16:00 CST 2016

Total time taken to generate the page: 0.08512 seconds