Urgent.. Please NLS_LANG Problem

[gnagesh]

Originally posted by sumit
Hi Nagesh

Is your problem solved? Let me know. I hope I can give u the solution.

Thanks
Sumit

No. Not Yet. You can shed some light on this.

Thanks In Advance.

[gnagesh]

Hi Guru's

Still I am stucked up with this problem. I had set
NLS_LANG=AMERICAN_AMERICA.UTF8, and the problem still exists. Please Help.. When I use sqlplus to select the data "????" are appeariing.

Thanks In Advance.

[sumit]

Hi ,

What is the CHARACTER SET of the database where from the export has been taken?

And what is the character set of ur current database ?

Tell me that first. Then I will tell u what to do next.

Thanks
Sumit

[sumit]

Hello

I hope , the O/S in ur export server is different than import server.

U r using Solaris Server. Right? But do u know what is the O/S? is it Chinese ?

For example if my export server is JAPANESE O/S and my local database is english O/S then you will face this type of problem.

Is that same? or different as I mentioned.

Thanks
Sumit

[gnagesh]

Thank You Summit.

Basically I am using SunOs Server. My Source(EXP) and target (IMP) database's are on the same BOX. And My NLS_CHARCTER_SET is UTF8.

I hope this information helps you to analyze the problem.

Thanks In Advance.

[gnagesh]

Hi

Still I am seeking your help. Please Help me.


Thanks In Advance.

[soniaarora]

I get export from a database with Japanese char set. Just before doing the import, I do:
export NLS_LANG="AMERICAN_AMERICA.JA16SJIS"

Try all these possibilities. Check ur export log file and see what is specified before doing the export.

[gnagesh]

Originally posted by soniaarora
I get export from a database with Japanese char set. Just before doing the import, I do:
export NLS_LANG="AMERICAN_AMERICA.JA16SJIS"

Try all these possibilities. Check ur export log file and see what is specified before doing the export.

I did but I exported NLS_LANG=AMERICAN_AMERICA.UTF8, not with "". Is it wrong?

Thanks In Advance

[soniaarora]

I dont know what significance "" has in this case. Y dont u try it and see.

[kgb]

My understanding is:
1) you made dump file of UTF8 database with NLS_LANG= ...
UTF8
2) you loaded dump file to UTF8 database with NLSLANG= ... UTF8
3) then you tryed to make s select from the same Solaris Box and got ????.
That is correct result in that case.

Question:
1) Before making query did you change your NLS_LANG to be Chanese?
It must be the same character set Chinese records were created with.
2) Does your Solaris BOx has Chinese character set installed?