×ðÁú¿­Ê±¹ÙÍøµÇ¼

oracleÔõô»»³ÉÖÐÎÄ

ÔÚ oracle Êý¾Ý¿âÖн«ÓïÑÔÇл»ÎªÖÐÎÄÐèÒªÒÔÏ°취£º1. ½¨ÉèÐÂÖÐÎÄÓû§£»2. ÉèÖÃÓû§ÓïÑÔΪ¡°simplified chinese_china¡±£»3. ÉèÖÃÓû§×Ö·û¼¯Îª¡°al32utf8¡±£»4. ÅþÁ¬ÐÂÓû§£»5. ÑéÖ¤ÓïÑÔÉèÖá£

ÔÚ Oracle Êý¾Ý¿âÖÐÇл»ÓïÑÔΪÖÐÎÄ

ÎÊÌ⣺ÔõÑùÔÚ Oracle Êý¾Ý¿âÖн«ÓïÑÔÇл»ÎªÖÐÎÄ£¿

»Ø¸²£º

ÔÚ Oracle Êý¾Ý¿âÖн«ÓïÑÔÇл»ÎªÖÐÎÄÐèÒªÒÔÏ°취£º

1. ½¨ÉèÒ»¸öÐÂÓû§

CREATE USER ÖÐÎÄ_Óû§ IDENTIFIED BY ÖÐÎÄÃÜÂë;
GRANT CONNECT TO ÖÐÎÄ_Óû§;

µÇ¼ºó¸´ÖÆ

2. ΪÐÂÓû§ÉèÖÃÓïÑÔ

ALTER USER ÖÐÎÄ_Óû§ SET NLS_LANGUAGE = 'SIMPLIFIED CHINESE_CHINA';

µÇ¼ºó¸´ÖÆ

3. ΪÐÂÓû§ÉèÖÃ×Ö·û¼¯

ALTER USER ÖÐÎÄ_Óû§ SET NLS_CHARACTERSET = 'AL32UTF8';

µÇ¼ºó¸´ÖÆ

4. ÅþÁ¬ÐÂÓû§

CONNECT ÖÐÎÄ_Óû§/ÖÐÎÄÃÜÂë;

µÇ¼ºó¸´ÖÆ

5. ÑéÖ¤ÓïÑÔÉèÖÃ

SELECT USER, NLS_LANGUAGE, NLS_CHARACTERSET FROM V$NLS_PARAMETERS;

µÇ¼ºó¸´ÖÆ

Êä³ö£º

USER                  NLS_LANGUAGE     NLS_CHARACTERSET
---------------------- ----------------- ---------------------
ÖÐÎÄ_Óû§            SIMPLIFIED CHINESE_CHINA  AL32UTF8

µÇ¼ºó¸´ÖÆ

×¢ÖØ£º

È·±£Óû§ÓÐ×ã¹»µÄȨÏÞ½¨ÉèÐÂÓû§ºÍÐÞ¸ÄÓïÑÔÉèÖá£

AL32UTF8 ×Ö·û¼¯Ö§³ÖÖÐÎÄ unicode ×Ö·û¡£

¿ÉÒÔƾ֤ÐèÒª½« NLS_LANGUAGE ÉèÖÃΪ ‘TRADITIONAL CHINESE_CHINA’ ÒÔʹÓ÷±ÌåÖÐÎÄ¡£

ÒÔÉϾÍÊÇoracleÔõô»»³ÉÖÐÎĵÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í×ðÁú¿­Ê±¹ÙÍøµÇ¼ÂËÓÍ»úÍø¹Ù·½Ì¬¶È£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼

13452372176

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎ壬9:30-18:30£¬½ÚãåÈÕÐÝÏ¢

QR code
ÍøÕ¾µØͼ