Àí½âORACLEÊý¾Ý¿â×Ö·û¼¯
Ò»£®ÒýÑÔ
ORACLE
Êý¾Ý¿â×Ö·û¼¯£¬¼´Oracle
È«Çò»¯Ö§³Ö(Globalization Support)
£¬»ò¼´¹ú¼ÒÓïÑÔÖ§³Ö£¨NLS
£©Æä×÷ÓÃÊÇÓñ¾¹úÓïÑԺ͸ñʽÀ´´æ´¢¡¢´¦ÀíºÍ¼ìË÷Êý¾Ý¡£ÀûÓÃÈ«Çò»¯Ö§³Ö£¬ORACLE
ΪÓû§Ìṩ×Ô¼ºÊìϤµÄÊý¾Ý¿âĸÓï»·¾³£¬ÖîÈçÈÕÆÚ¸ñʽ¡¢Êý×Ö¸ñʽºÍ´æ´¢ÐòÁеȡ£Oracle
¿ÉÒÔÖ§³Ö¶àÖÖÓïÑÔ¼°×Ö·û¼¯£¬ÆäÖÐoracle8i
Ö§³Ö48
ÖÖÓïÑÔ¡¢76
¸ö¹ú¼ÒµØÓò¡¢229
ÖÖ×Ö·û¼¯£¬¶øoracle9i
ÔòÖ§³Ö57
ÖÖÓïÑÔ¡¢88
¸ö¹ú¼ÒµØÓò¡¢235
ÖÖ×Ö·û¼¯¡£ÓÉÓÚoracle
×Ö·û¼¯ÖÖÀà¶à£¬ÇÒÔÚ´æ´¢¡¢¼ìË÷¡¢Ç¨ÒÆoracle
Êý¾Ýʱ¶à¸ö»·½ÚÓë×Ö·û¼¯µÄÉèÖÃÃÜÇÐÏà¹Ø£¬Òò´ËÔÚʵ¼ÊµÄÓ¦ÓÃÖУ¬Êý¾Ý¿â¿ª·¢ºÍ¹ÜÀíÈËÔ±¾³£»áÓöµ½ÓйØoracle
×Ö·û¼¯·½ÃæµÄÎÊÌâ¡£±¾ÎÄͨ¹ýÒÔϼ¸¸ö·½Ãæ²ûÊö£¬¶Ôoracle
×Ö·û¼¯×ö¼òÒª·ÖÎö
¶þ£®×Ö·û¼¯»ù±¾ÖªÊ¶
2.1
×Ö·û¼¯
ʵÖʾÍÊǰ´ÕÕÒ»¶¨µÄ×Ö·û±àÂë·½°¸£¬¶ÔÒ»×éÌØ¶¨µÄ·ûºÅ£¬·Ö±ð¸³Ó費ͬÊýÖµ±àÂëµÄ¼¯ºÏ¡£Oracle
Êý¾Ý¿â×îÔçÖ§³ÖµÄ±àÂë·½°¸ÊÇUS7ASCII
¡£
Oracle
µÄ×Ö·û¼¯ÃüÃû×ñÑÒÔÏÂÃüÃû¹æÔò
:
<Language><bit size><encoding>
¼´: <
ÓïÑÔ><
±ÈÌØÎ»Êý><
±àÂë
>
±ÈÈç: ZHS16GBK
±íʾ²ÉÓÃGBK
±àÂë¸ñʽ¡¢16
루Á½¸ö×Ö½Ú£©¼òÌåÖÐÎÄ×Ö·û¼¯
2.2
×Ö·û±àÂë·½°¸
<st1:chsdate year="1899" month="12" day="30" islunardate="False" isrocdate="False" w:st="on">2.2.1
</st1:chsdate>
µ¥×Ö½Ú±àÂë
£¨1
£©µ¥×Ö½Ú7
λ×Ö·û¼¯£¬¿ÉÒÔ¶¨Òå128
¸ö×Ö·û£¬×î³£ÓõÄ×Ö·û¼¯Îª
US7ASCII
£¨2
£©µ¥×Ö½Ú8
λ×Ö·û¼¯£¬¿ÉÒÔ¶¨Òå256
¸ö×Ö·û£¬ÊʺÏÓÚÅ·Ö޴󲿷ֹú¼Ò
ÀýÈ磺WE8ISO8859P1(
Î÷Å·¡¢8
λ¡¢ISO
±ê×¼8859P1
±àÂë
)
2.2.2
¶à×Ö½Ú±àÂë
£¨1
£©±ä³¤¶à×Ö½Ú±àÂë
ijЩ×Ö·ûÓÃÒ»¸ö×Ö½Ú±íʾ£¬ÆäËü×Ö·ûÓÃÁ½¸ö»ò¶à¸ö×Ö·û±íʾ£¬±ä³¤¶à×Ö½Ú±àÂë³£ÓÃÓÚ¶ÔÑÇÖÞÓïÑÔµÄÖ§³Ö£¬
ÀýÈçÈÕÓï¡¢ººÓï¡¢Ó¡µØÓïµÈ
ÀýÈ磺AL32UTF8
£¨ÆäÖÐAL
´ú±íALL,
Ö¸ÊÊÓÃÓÚËùÓÐÓïÑÔ£©¡¢
zhs16cgb231280
£¨2
£©¶¨³¤¶à×Ö½Ú±àÂë
&nbs
Ïà¹ØÎĵµ£º
Òª½øÐÐѹÁ¦²âÊÔ£¬Öмä¼þʹÓÃWEBLOGIC 816
£¬Êý¾Ý¿â°æ±¾Îª11.1.0.6 RAC
£¬Ñ¹Á¦²âÊÔ¹¤¾ßΪLOADRUNNER 8.0
¡£²âÊÔµ¥ÊµÀýÓëRAC
»·¾³¸÷¸ö½ÚµãµÄ¸ºÔØÇé¿ö¡£
ÔÚWEBLOGIC
ÉÏÅäÖÃÁËÒ»¸ö¶à³Ø£¬ÀûÓÃWEBLOGIC
ÌṩµÄ¸ºÔؾùºâ²ßÂÔ£¬½«²¢·¢¾ùºâµÄ·Ö±ðµ½Á½¸ö½ÚµãÉÏ¡£
µ«ÊDzâÊÔ·¢ÏÖ£¬Ò»µ©ÔËÐÐ
ÁËÒ»¶Îʱ¼ä£¬ËùÓе ......
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
create or replace procedure adddept(deptno number,dname varchar2,loc varchar2)
as
begin
insert into dept values(deptno,dname,loc);
end;
È»ºóÄØ£¬ÔÚjavaÀïµ÷ÓÃʱ¾ÍÓÃÏÂÃæµÄ´úÂ룺
public class TestProcedure {
Connectio ......
dc-test2<oracle>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 25 19:23:35 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> desc v$datafile;
SP2-0640: Not connected
SP2-0641: "DESCRIBE" requires connection to server
SQL> conn / a ......