Home » RDBMS Server » Server Administration » when I insert chinese character into my oracle ,my oralce display "???? "?
when I insert chinese character into my oracle ,my oralce display "???? "? [message #55910] Mon, 24 February 2003 04:18 Go to next message
eng_llw
Messages: 8
Registered: February 2003
Junior Member
oracle 8.0.5
when I insert chinese character into my oracle,it display "????????",I attempt update the field(display "???") to chinese character ,the sqlplus is no response,I have to close it to reopen.

in regedit:
NLS_LANG £ºsimplified chinese_china.zhs16GBK

select * from v$nls_parameters;
__________________________________________
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY RMB
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET ZHS16GBK

Report message to a moderator

Re: when I insert chinese character into my oracle ,my oralce display "???? "? [message #55923 is a reply to message #55910] Mon, 24 February 2003 18:40 Go to previous messageGo to next message
Keanu Wong
Messages: 2
Registered: February 2003
Junior Member
My oracle is 9.0.1 and OS is Windows XP,the value of NLS_CHARACTERSET is ZHS16GBK,so I think it could be your DB server's OS characterset is not compliable.

Report message to a moderator

Re: when I insert chinese character into my oracle ,my oralce display "???? "? [message #55928 is a reply to message #55923] Tue, 25 February 2003 02:45 Go to previous message
eng_llw
Messages: 8
Registered: February 2003
Junior Member
I delete the database ,and rebuild it ,then the problem is ok!

Report message to a moderator

Previous Topic: Oracle instance does not start
Next Topic: Interpretation of TKPROF output
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:40:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.