about sqlplus character [message #254524] |
Fri, 27 July 2007 01:01 |
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 #254554 is a reply to message #254525] |
Fri, 27 July 2007 02:07 |
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 #254577 is a reply to message #254566] |
Fri, 27 July 2007 03:05 |
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~~
|
|
|
|
|
|
|