设置ç¯å¢åé(ä¿®æ¹PATHåTNS_ADMINç¯å¢åé):
对äºNLS_LANGç¯å¢åé, æ好设置æåæ°æ®åºç«¯ä¸è´, é¦å
ä»æ°æ®åºç«¯æ¥è¯¢å符éä¿¡æ¯:
å¦å¾ï¼ä»¥systemæ®éç¨æ·ç»é就好ï¼è¿å»åæ°å»ºä¸ä¸ªSQL WINDOWï¼è¾å
¥
SQL> select userenv('language') nls_lang from dual;
æççµèç»æ为
NLS_LANG
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
å³å»"æççµè" - "å±æ§" - "é«çº§" - "ç¯å¢åé" - "ç³»ç»ç¯å¢åé":(win8.1ç³»ç»ï¼èªå·±ä¸ç½æ¥æä¹æ¾åºé«çº§ä¸çç³»ç»åé)
1>.éæ©"Path" - ç¹å»"ç¼è¾", æ "D:\app\orcl\product\instantclient_12_1;" å å
¥;
2>.ç¹å»"æ°å»º", åéå设置为"TNS_ADMIN", åéå¼è®¾ç½®ä¸º"D:\app\orcl\product\instantclient_12_1;", ç¹å»"ç¡®å®";
3>.ç¹å»"æ°å»º", åéå设置为"NLS_LANG", åéå¼è®¾ç½®ä¸º"AMERICAN_AMERICA.ZHS16GBK", ç¹å»"ç¡®å®";
æåç¹å»"ç¡®å®"éåº.
温馨提示:内容为网友见解,仅供参考