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Ôõô»»³ÉÖÐÎĵÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡