ÔÚSQL*PlusÖÐÓÃinsert²å½øµÄ¶¼ÊÇÖÐÎĵģ¬ÎªÊ²Ã´Ò»´æÈë·þÎñÆ÷ºó£¬ÔÙselect³öµÄ¾ÍÊÇ ¡±
¡°ÓеÄʱºò£¬·þÎñÆ÷Êý¾ÝÏȵ¼³ö£¬ÖØ×°·þÎñÆ÷£¬ÔÙµ¼ÈëÊý¾Ý£¬½á¹û£¬·¢ÉúÊý¾Ý²éѯ³É ¡±
¡¡
ÕâЩÎÊÌ⣬һ°ãÊÇÒòΪ×Ö·û¼¯ÉèÖò»¶ÔÔì³ÉµÄ¡£
·Ç³£¾ÃÒÔÀ´£¬×Ö·û¼¯Ò»Ö±ÊÇÀ§ÈÅ×ÅÖÚ¶àOracle°®ºÃÕßµÄÎÊÌ⣬±ÊÕß´ÓÊÂOracleÊý¾Ý¿â¹ÜÀíºÍÓ¦ÓÃÒѼ¸ÄêÁË£¬¾³£½Óµ½¿Í»§µÄÀàËÆÉÏÃæÌáµ½µÄÓйØÊý¾Ý¿â×Ö·û¼¯µÄ¡°¸æ¼±¡±ºÍ¡°Çó¾È¡±£¬ÔÚ´ËÎÒÃǾÍÕâ¸öÎÊÌâ×öһЩ·ÖÎöºÍ̽ÌÖ¡£
Ê×ÏÈ£¬ÎÒÃÇÒªÃ÷ȷʲôÊÇ×Ö·û¼¯£¿×Ö·û¼¯ÊǸö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÀ¨¹Øϵ,Èçus7ascii¾ÍÊÇzhs16gbkµÄ×Ó¼¯, ´Óus7asciiµ½zhs16gbk²»»áÓÐÊý¾Ý½âÊÍÉϵÄÎÊÌâ,²»»áÓÐÊý¾Ý¶ªÊ§,Oracle¶ÔÕâÖÖÎÊÌâÒ²ÐèÇó´Ó×Ó¼¯µ½³¬¼¯µÄµ¼³öÊÜÖ§³Ö,·´Ö®²»ÐС£ÔÚËùÓеÄ×Ö·û¼¯ÖÐutf8Ó¦¸ÃÊÇ×î´ó,ÒòΪËû»ùÓÚunicode,Ë«×Ö½Ú±£´æ×Ö·û(Ò²Òò´ËÔÚ´æ´¢¿Õ¼äÉÏÕ¼Óøü¶à)¡£
Æä´Î£¬Ò»µ©Êý¾Ý¿â´´½¨ºó£¬Êý¾Ý¿âµÄ×Ö·û¼¯ÊDz»ÄܸĶ¯µÄ¡£Òò´Ë£¬ÔÚÉè¼ÆºÍ°²×°Ö®³õ¿¼ÂÇʹÓÃÄÄÒ»ÖÖ×Ö·û¼¯ÊÇÊ®·ÖÖØÒªµÄ¡£Êý¾Ý¿â×Ö·û¼¯Ó¦¸ÃÊDzÙ×÷ϵͳ±¾µØ×Ö·û¼¯µÄÒ»¸ö³¬¼¯¡£´æÈ¡Êý¾Ý¿âµÄ¿Í»§Ê¹ÓõÄ×Ö·û¼¯½«¾ö¶¨Ñ¡ÔñÄÄÒ»¸ö³¬¼¯£¬¼´Êý¾Ý¿â×Ö·û¼¯Ó¦¸ÃÊÇËùÓпͻ§×Ö·û¼¯µÄ³¬¼¯¡£
ÔÚʵ¼ÊÓ¦ÓÃÖУ¬ºÍ×Ö·û¼¯ÎÊÌâ¹Øϵ×î´óµÄ¿ÖžÍÊÇexp/impÁË¡£ÔÚ×öexp/impʱ£¬Èç¹ûClient ºÍServerµÄnls_langÉèÖÃÊÇÏàͬµÄ£¬Ò»°ã¾ÍûÓÐÎÊÌâµÄ¡£²»¹ý£¬ÒªÔÚÁ½¸ö²»Í¬×Ö·û¼¯µÄϵͳ֮¼äµ¼Êý¾Ý¾Í¾³£»áÓÐÕâÑù»òÄÇÑùµÄÎÊÌ⣬È磬µ¼³öʱÊý¾Ý¿âµÄÏÔʾÕý³££¬ÊÇÖÐÎÄ£¬µ±µ¼Èëµ½ÆäËûϵͳʱ£¬¾Í³ÉÁËÂÒÂ룬ÕâÒ²ÊÇÒ»Àà³£¼ûÎÊÌâ¡£
Ä¿Ç°£¬½éÉÜһЩºÍ×Ö·û¼¯ÓйصÄNLS_LANG²ÎÊý£¬
NLS_LANG¸ñʽ£º
NLS_LANG = language_territory.charset
ÓÐÈý¸ö×é³É²¿·Ö£¨ÓïÑÔ¡¢µØÓòºÍ×Ö·û¼¯£©£¬Ã¿¸ö³É·Ö¿ØÖÆÁËNLS×Ó¼¯µÄÌØÐÔ¡£ÆäÖУºlanguage Ö¸¶¨·þÎñÆ÷ÏûÏ¢µÄÓïÑÔ¡£
territory Ö¸¶¨·þÎñÆ÷µÄÈÕÆÚºÍÊý×Ö¸ñʽ¡£
charset Ö¸¶¨×Ö·û¼¯
ÀýÈ磺
AMERICAN_AMERICA.US7SCII
AMERICAN _ AMERICA. ZHS16GBK
¸üÓÐһЩ×Ó¼¯ÄܸüÃ÷È·¶¨ÒåNLS_LANG²ÎÊý£º
DICT.BASE Êý¾Ý×Öµä»ù±¾ ±í°æ±¾
DBTIMEZONE Êý¾Ý¿âʱÇø
NLS_LANGUAGE ÓïÑÔ
NLS_TERRITORY µØÓò
NLS_CURRENCY ±¾µØ»õ±Ò×Ö·û
NLS_ISO_CURRENCY ISO»õ±Ò×Ö·û
NLS_NUMERIC_CHARACTERS СÊý×Ö·ûºÍ×é ·Ö¸ô¿ª
NLS_CHARACTERSET ×Ö·û¼¯
NLS_CALENDAR ÈÕÀúϵͳ
NLS_DATE_FORMAT ȱʡµÄÈÕÆÚ¸ñʽ
NLS_DATE_LANGUAGE ȱʡµÄÈÕÆÚÓïÑÔ
NLS_SORT ×Ö·ûÅÅÐòÐòÁÐ
NLS_TIME_FORMAT ʱ¼ä¸ñʽ
NLS_TIMESTAMP_FORMAT ʱ¼ä´Á¸ñʽ
¡¡
ͨ¹ýprops$¶¯Ì¬ÐÔÄÜÊÓͼ£¬ÎÒÃÇÄܲ鿴Êý¾Ý¿âµÄ×Ö·û¼¯ÐÅÏ¢£º
$> sqlplus internal
SQL> desc props$
Name Type Nullable Default Comments
NAME VARCHAR2(30)
VALUE$ VARCHAR2(4000) Y
COMMENT$ VARCHAR2(4000) Y
SQL> set arraysize 1
SQL> col value$ format a40
SQL> select name,value$ from props$ where name=¡®NLS_CHARACTERSET¡¯;
NAME VALUE$
NLS_CHARACTERSET ZHS16GBK
SQL> select * from sys.props$;
NAME VALUE$
DICT.BASE 2
DBTIMEZONE 0:00
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET ZHS16GBK
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI. SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.
SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON- RR HH.MI. SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET ZHS16GBK
NLS_RDBMS_VERSION 8.1.6.0.0
NAME VALUE$
GLOBAL_DB_NAME SCPDB1
EXPORT_VIEWS_VERSION 8
22 rows selected
SQL>
´Ó½á¹ûÄÜ¿´³ö£º
NLS_LANG = AMERICAN _ AMERICA. ZHS16GBK
ËäÈ»£¬Êý¾Ý¿âµÄ×Ö·û¼¯ÊÇÔÚcreate databaseµÄʱºòÖ¸¶¨µÄ£¬ÒÔºó²»ÔÊÐí¸Ä¶¯£¬µ«ÔÚÒ»¸öÒѽ¨Á¢ºÃµÄÊý¾Ý¿âÉÏ£¬ÎÒÃÇÄÜͨ¹ýÐÞ¸ÄSYS.PROPS$À´ÐÞ¸ÄÖ÷ÒªÊǶÔÓ¦¿Í»§¶ËµÄÏÔʾ£¬ºÍ´æ´¢Î޹ء£
È磺
SQL> conn / as sysdba
Connected.
SQL> SQL> select * from sys.props$
2 WHERE NAME=¡®NLS_LANGUAGE¡¯;
NAME VALUE$
NLS_LANGUAGE AMERICAN
SQL>
SQL> UPDATE sys.PROPS$ SET VALUE$=¡®SIMPLIFIED CHINESE¡¯
2 WHERE NAME=¡®NLS_LANGUAGE¡¯;
1 row updated
SQL>
SQL> select * from sys.props$
2 WHERE NAME=¡®NLS_LANGUAGE¡¯;
NAME VALUE$
NLS_LANGUAGE SIMPLIFIED CHINESE
SQL>
ͨ³£³öÏÖÎÊÌâµÄÔÒò£¬¿É·ÖΪÈýÖÖ£º
1. ·þÎñÆ÷Ö¸¶¨×Ö·û¼¯ºÍ¿Í»§×Ö·û¼¯²»Í¬£¬¶øºÍ¼ÓÔØÊý¾Ý×Ö·û¼¯Ò»Ö¡£
½â¾ö·½·¨£º¶ÔÓÚÕâÖÖÇé¿ö£¬Ö»ÐèÒªÉèÖÿͻ§¶Ë×Ö·û¼¯ºÍ·þÎñÆ÷¶Ë×Ö·û¼¯Ò»Ö¾ÍÄÜÁË£¬¾ßÌå²Ù×÷ÈçÏ£º
* ²é¿´µ±Ç°×Ö·û¼¯£º
SQL> select * from sys.props$
2 WHERE NAME=¡®NLS_CHARACTERSET¡¯;
NAME VALUE$
NLS_CHARACTERSET ZHS16GBK
SQL>
ÄÜ¿´³ö£¬Ä¿Ç°·þÎñÆ÷¶ËOracleÊý¾Ý¿âµÄ×Ö·û¼¯Îª¡®ZHS16GBK¡¯
* ¸ù¾Ý·þÎñÆ÷µÄ×Ö·û¼¯ÔÚ¿Í»§¶Ë×÷ÏàÓ¦µÄÉèÖûò°²×°OracleµÄ¿Í»§¶ËÈí¼þʱָ¶¨£º
Èç¹û»¹Ã»°²×°¿Í»§¶Ë£¬ÄÇôÔÚ°²×°¿Í»§¶Ëʱ£¬Ö¸¶¨ºÍ·þÎñÆ÷ÏàÎǺϵÄ×Ö·û¼¯¼´¿É£»Èç¹ûÒÑ°²×°ºÃÁË¿Í»§¶Ë£¬²¢ÇÒ¿Í»§¶ËΪ sql*net 2.0 ÒÔÏ°汾£¬½øÈëÊÓ´°ÏµÍ³µÄϵͳĿ¼£¬±à¼oracle.iniÎļþ£¬ÓÃUS7ASCIIÌæ»»Ô×Ö·û¼¯£¬ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÉèÖÃÉúЧ£»·ñÔò£¬Èç¹û£¬¿Í»§¶ËΪ sql*net 2.0 ÒÔÉÏ°æ±¾£¬ÔÚWin98 Ï ÔËÐÐREGEDIT,µÚÒ»²½Ñ¡HKEY_LOCAL_MACHINE,µÚ¶þ²½Ñ¡ÔñSOFTWARE£¬ µÚÈý²½Ñ¡ÔñOracle