如题所述
1ãæ¹å®¢æ·ç«¯å符éï¼éè¿WINDOWSçè¿è¡èåè¿è¡Regeditï¼ä¿®æ¹æ³¨å表
Start -> Run -> Rededit <-|
Under registry Editor - > HKEY_LOCAL_MACHINE -> SOFTWARE ->ORACLE->KEY_XE->RIGHT WINDOW DOUBLE CLICK NLS_LANG -> CHANGE VALUE TO "AMERICAN_AMERICA.UTF8" ->OK ->CLOSE REGISTRY
æ£ç¡®è®¾ç½®ORACLE客æ·ç«¯å符éçæ¹æ³ï¼
oracle客æ·ç«¯å符é设置éè¦åæå¡å¨ç«¯ä¸è´ï¼å¦åä¼åºç°ä¹±ç é®é¢ã
é¦å è¿æ¥æå¡å¨ï¼æ¥è¯¢æå¡å¨ç«¯è®¾ç½®ï¼
select * from v$nls_parameters;
æ¾å°ï¼
NLS_LANGUAGE
NLS_TERRITORY
NLS_CHARACTERSET
ç¯å¢åénls_lang便æ¯ç±è¿ä¸é¨åç»æ
NLS_LANG = language_territory.charset
æ¯å¦ï¼
NLS_LANG = American_Japan.JA16SJIS
2ãæ¹æå¡å¨ç«¯å符éï¼éè¿ORACLEçSQL PLUSå½ä»¤çªå£æ¹
å¨SQL*PLUS ä¸ï¼ä»¥DBAç»å½
conn ç¨æ·å as sysdba
ç¶åæ§è¡ä»¥ä¸å½ä»¤
>shutdown immediate; (ædatabaseåäº)
>startup mount; (ædatabaseéå¼å»å¯æ´æ¹æ åµ)
>alter system enable restricted session;
>alter system set job_queue_processes=0;
>alter system set aq_tm_processes=0;
>alter database open;
>alter database character set utf8;
OR
>alter database character set internal_use utf8;
>shutdown immediate;
>startup; (éå¼æ£å¸¸oracle)
ORACLEæ°æ®åºå符éä¿®æ¹å®æï¼
Start -> Run -> Rededit <-|
Under registry Editor - > HKEY_LOCAL_MACHINE -> SOFTWARE ->ORACLE->KEY_XE->RIGHT WINDOW DOUBLE CLICK NLS_LANG -> CHANGE VALUE TO "AMERICAN_AMERICA.UTF8" ->OK ->CLOSE REGISTRY
æ£ç¡®è®¾ç½®ORACLE客æ·ç«¯å符éçæ¹æ³ï¼
oracle客æ·ç«¯å符é设置éè¦åæå¡å¨ç«¯ä¸è´ï¼å¦åä¼åºç°ä¹±ç é®é¢ã
é¦å è¿æ¥æå¡å¨ï¼æ¥è¯¢æå¡å¨ç«¯è®¾ç½®ï¼
select * from v$nls_parameters;
æ¾å°ï¼
NLS_LANGUAGE
NLS_TERRITORY
NLS_CHARACTERSET
ç¯å¢åénls_lang便æ¯ç±è¿ä¸é¨åç»æ
NLS_LANG = language_territory.charset
æ¯å¦ï¼
NLS_LANG = American_Japan.JA16SJIS
2ãæ¹æå¡å¨ç«¯å符éï¼éè¿ORACLEçSQL PLUSå½ä»¤çªå£æ¹
å¨SQL*PLUS ä¸ï¼ä»¥DBAç»å½
conn ç¨æ·å as sysdba
ç¶åæ§è¡ä»¥ä¸å½ä»¤
>shutdown immediate; (ædatabaseåäº)
>startup mount; (ædatabaseéå¼å»å¯æ´æ¹æ åµ)
>alter system enable restricted session;
>alter system set job_queue_processes=0;
>alter system set aq_tm_processes=0;
>alter database open;
>alter database character set utf8;
OR
>alter database character set internal_use utf8;
>shutdown immediate;
>startup; (éå¼æ£å¸¸oracle)
ORACLEæ°æ®åºå符éä¿®æ¹å®æï¼
温馨提示:答案为网友推荐,仅供参考