Home » Other » Client Tools » about sqlplus character
about sqlplus character [message #254524] Fri, 27 July 2007 01:01 Go to next message
hot3b3c
Messages: 8
Registered: July 2007
Junior Member
Dear All:
My database NLS_CHARACTERSET is UTF8,and table data is TRADITIONAL CHINESE;when i use O.E.M (Table data Editor),i can get the correct TRADITIONAL CHINESE data,But,when i use sqlplus,sqlplus worksheet or Toad (sqlplus Editor) to select data,i'll get the "??"..how to fix that?

My OS platform is :windows XP (TRADITIONAL CHINESE version)
chcp code is 950.
NLS_LANG set is "TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5"

I've tried to modify NLS_LANG to "AMERICAN_AMERICA.UTF8",
but,it still get the "??"...

Could someone help me to solve this problem?
Thanks...


Re: about sqlplus character [message #254525 is a reply to message #254524] Fri, 27 July 2007 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe SQL*Plus and TOAD don't support chinese characters, that is they are unable to display these ones whatever are your settings.

Regards
Michel
Re: about sqlplus character [message #254554 is a reply to message #254525] Fri, 27 July 2007 02:07 Go to previous messageGo to next message
hot3b3c
Messages: 8
Registered: July 2007
Junior Member
Dear Michel:
thank you for replied so soon..
I have another database NLS_CHARACTERSET is ZHT16BIG5.
when i use the same SQLPLUS,TOAD to connect,it'll display the correct chinese characters..

Any ideas?
Re: about sqlplus character [message #254566 is a reply to message #254554] Fri, 27 July 2007 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To summarize, using the same client:
1/ With OEM, you can see correct data from database A
2/ With SQL*Plus or TOAD, you cannot see correct data from database A
3/ With SQL*Plus or TOAD, you can see correct data from database B
Is this correct?

Regards
Michel
Re: about sqlplus character [message #254577 is a reply to message #254566] Fri, 27 July 2007 03:05 Go to previous messageGo to next message
hot3b3c
Messages: 8
Registered: July 2007
Junior Member
Sorry,let me make it clearly..
like below:
------------------------------------------------------------
database A : UTF8 (stored chinese data)
database B: ZHT16BIG5 (stored chinese data)

client 1 NLS_LANG: TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5
client 2 NLS_LANG: AMERICAN_AMERICA.UTF8

client tools : sqlplus,TOAD,OEM

client 1 + database A:
Result: OEM:correct
sqlplus & Toad :incorrect

client 2 + database A:
Result: OEM:correct
sqlplus & Toad :incorrect

client 1 + database B:
Result: OEM:correct
sqlplus & Toad :correct

client 2 + database B:
Result: OEM:correct
sqlplus & Toad :incorrect
==============================================

thanks~~
Re: about sqlplus character [message #254586 is a reply to message #254577] Fri, 27 July 2007 04:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Clients are remote ones for all cases?

Regards
Michel
Re: about sqlplus character [message #254753 is a reply to message #254586] Fri, 27 July 2007 19:56 Go to previous messageGo to next message
hot3b3c
Messages: 8
Registered: July 2007
Junior Member
Michel...
that's right..
All clients are windows xp ,
and database server is solaris 9.

thanks..
Re: about sqlplus character [message #254770 is a reply to message #254753] Sat, 28 July 2007 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What are the data in the ACP and OEMCP registry values under HKLM\SYSTEM\CurrentControlSet\Control\Nls\CodePage key, on both client?

Regards
Michel

[Updated on: Sat, 28 July 2007 01:17]

Report message to a moderator

Re: about sqlplus character [message #254873 is a reply to message #254770] Sun, 29 July 2007 21:31 Go to previous message
hot3b3c
Messages: 8
Registered: July 2007
Junior Member
Michel:
The ACP and OEMCP registry values is 950.

thanks.
Previous Topic: procedure error
Next Topic: How to execute a .sql file in sqlplus editor ?
Goto Forum:
  


Current Time: Thu Mar 28 11:44:25 CDT 2024