ä¸ãpl/sql developer ä¸æå段æ¾ç¤ºä¹±ç
åå ï¼å 为æ°æ®åºçç¼å·æ ¼å¼åpl /sql developerçç¼ç æ ¼å¼ä¸ç»ä¸é æçã
äºãæ¥çåä¿®æ¹oracleæ°æ®åºå符éï¼
select userenv('language') from dual;
æ¥è¯¢ç»æï¼
SIMPLIFIED CHINESE_CHINA.AL32UTF8
--ä¿®æ¹oracleæ°æ®åºå符éï¼ï¼å¨SQL Plusä¸ï¼
sql> conn / as sysdba;
sql> shutdown immediate;
database closed.
database dismounted.
oracle instance shut down.
sql> startup mount;
oracle instance started.
total system global area 135337420 bytes
fixed size 452044 bytes
variable size 109051904 bytes
database buffers 25165824 bytes
redo buffers 667648 bytes
database mounted.
sql> alter system enable restricted session;
system altered.
sql> alter system set job_queue_processes=0;
system altered.
sql> alter system set aq_tm_processes=0;
system altered.
sql> alter database open;
database altered.
sql> alter database character set internal_use JA16SJIS;
sql> shutdown immediate;
sql> startup;
ä¸ãä¿®æ¹pl/sql developer çç¼ç æ ¼å¼ï¼
å¨windowsä¸å 建ä¸ä¸ªå为âNLS_LANGâçç³»ç»ç¯å¢åéï¼è®¾ç½®å
¶å¼ä¸ºâSIMPLIFIED CHINESE_CHINA.ZHS16GBKâï¼
ç¶åéæ°å¯å¨ pl/sql developerï¼è¿æ ·æ£ç´¢åºæ¥çä¸æå
容就ä¸ä¼æ¯ä¹±ç äºãå¦ææ³è½¬æ¢ä¸ºUTF8å符éï¼å¯ä»¥èµäºâNLS_LANGâ为 âAMERICAN_AMERICA.UTF8âï¼ç¶åéæ°å¯å¨ pl/sql developerãå
¶å®å符é设置åä¸
温馨提示:答案为网友推荐,仅供参考