Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle×Ö·û¼¯²âÊÔ

ÒÔÏ»شðÊôÓÚתÔØ£º
¾­³£¿´µ½Ò»Ð©ÅóÓÑÎÊORACLE×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî¡£
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆѧ¼ÆËãµÄ£¨ËùÒÔ½Ð×ö"¼ÆËã»ú"£©£¬µ«Ëæ׿¼ÊõµÄ·¢Õ¹£¬»¹ÐèÒª¼ÆËã»ú½øÐÐÆäËü·½ÃæµÄÓ¦Óô¦Àí¡£Õâ¾ÍÒªÇó¼ÆËã»ú²»½öÄÜ´¦ÀíÊýÖµ£¬»¹ÄÜ´¦ÀíÖîÈçÎÄ×Ö¡¢ÌØÊâ·ûºÅµÈÆäËüÐÅÏ¢£¬¶ø¼ÆËã»ú±¾ÉíÄÜÖ±½Ó´¦ÀíµÄÖ»ÓÐÊýÖµÐÅÏ¢£¬ËùÒÔ¾ÍÒªÇó¶ÔÕâЩÎÄ×Ö¡¢·ûºÅÐÅÏ¢½øÐÐÊýÖµ±àÂ룬×î³õµÄ×Ö·û¼¯ÊÇÎÒÃǶ¼·Ç³£ÊìϤµÄASCII£¬ËüÊÇÓÃ7¸ö¶þ½øÖÆλÀ´±íʾ128¸ö×Ö·û£¬¶øºóÀ´Ëæ×Ų»Í¬¹ú¼Ò¡¢×éÖ¯µÄÐèÒª£¬³öÏÖÁËÐíÐí¶à¶àµÄ×Ö·û¼¯£¬Èç±íʾÎ÷Å·×Ö·ûµÄISO8859ϵÁеÄ×Ö·û¼¯£¬±íʾºº×ÖµÄGB2312-80¡¢GBKµÈ×Ö·û¼¯¡£
×Ö·û¼¯µÄʵÖʾÍÊǶÔÒ»×éÌض¨µÄ·ûºÅ£¬·Ö±ð¸³Ó費ͬµÄÊýÖµ±àÂ룬ÒÔ±ãÓÚ¼ÆËã»úµÄ´¦Àí¡£
×Ö·û¼¯Ö®¼äµÄת»»¡£×Ö·û¼¯¶àÁË£¬¾Í»á´øÀ´Ò»¸öÎÊÌ⣬±ÈÈçÒ»¸ö×Ö·û£¬ÔÚijһ×Ö·û¼¯Öб»±àÂëΪһ¸öÊýÖµ£¬¶øÔÚÁíÒ»¸ö×Ö·û¼¯Öб»±àÂëΪÁíÒ»¸öÊýÖµ£¬±ÈÈçÎÒÀ´´´ÔìÁ½¸ö×Ö·û¼¯demo_charset1Óëdemo_charset2£¬ÔÚdemo_charset1ÖУ¬Îҹ涨ÁËÈý¸ö·ûºÅµÄ±àÂëΪ£ºA£¨0001£©£¬B£¨0010£©£¬£¿£¨1111£©£»¶øÔÚdemo_charset2ÖУ¬ÎÒÒ²¹æ¶¨ÁËÈý¸ö·ûºÅµÄ±àÂëΪ£ºA£¨1001£©£¬C£¨1011£©£¬£¿£¨1111£©£¬ÕâʱÎÒ½Óµ½Ò»¸öÈÎÎñ£¬Òª±àдһ¸ö³ÌÐò£¬¸ºÔðÔÚdemo_charset1Óëdemo_charset2Ö®¼ä½øÐÐת»»¡£ÓÉÓÚÖªµÀÁ½¸ö×Ö·û¼¯µÄ±àÂë¹æÔò£¬¶ÔÓÚdemo_charset1ÖеÄ0001£¬ÔÚת»»Îªdemo_charset2ʱ£¬Òª½«Æä±àÂë¸ÄΪ1001£»¶ÔÓÚdemo_charset1ÖеÄ1111£¬×ª»»Îªdemo_charset2ʱ£¬ÆäÊýÖµ²»±ä£»¶ø¶ÔÓÚdemo_charset1ÖеÄ0010£¬Æä¶ÔÓ¦µÄ×Ö·ûΪB£¬µ«ÔÚdemo_charset2ûÓжÔÓ¦µÄ×Ö·û£¬ËùÒÔ´ÓÀíÂÛÉÏÎÞ·¨×ª»»£¬¶ÔÓÚËùÓÐÕâÀàÎÞ·¨×ª»»µÄÇé¿ö£¬ÎÒÃÇ¿ÉÒÔ½«ËüÃÇͳһת»»ÎªÄ¿±ê×Ö·û¼¯ÖеÄÒ»¸öÌØÊâ×Ö·û£¨³ÆΪ"Ìæ»»×Ö·û"£©£¬±ÈÈçÔÚÕâÀïÎÒÃÇ¿ÉÒÔ½«£¿×÷ΪÌæ»»×Ö·û£¬ËùÒÔB¾Íת»»ÎªÁË£¿£¬³öÏÖÁËÐÅÏ¢µÄ¶ªÊ§£»Í¬ÑùµÀÀí£¬½«demo_charset2µÄC×Ö·ûת»»µ½demo_charset1ʱ£¬Ò²»á³öÏÖÐÅÏ¢¶ªÊ§¡£
ËùÒÔ˵£¬ÔÚ×Ö·û¼¯×ª»»¹ý³ÌÖУ¬Èç¹ûÔ´×Ö·û¼¯ÖеÄij¸ö×Ö·ûÔÚÄ¿±ê×Ö·û¼¯ÖÐûÓж¨Ò壬½«»á³öÏÖÐÅÏ¢¶ªÊ§¡£
Êý¾Ý¿â×Ö·û¼¯µÄÑ¡Ôñ¡£
ÎÒÃÇÔÚ´´½¨Êý¾Ý¿âʱ£¬ÐèÒª¿¼ÂǵÄÒ»¸öÎÊÌâ¾ÍÊÇÑ¡Ôñʲô×Ö·û¼¯Óë¹ú¼Ò×Ö·û¼¯£¨Í¨¹ýcreate databaseÖеÄCHARACTER SETÓëNATIONAL C


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle ÈÕÆÚÏÔʾӢÎĸñʽ

     ÎÒÃdzõѧÕß°²×°oracleµÄʱºò£¬×Ö·û¼¯Ñ¡ÔñµÄÒ»°ãÊǼòÌåÖÐÎĵĸñʽ£¬Õâ·½±ãÎÒÃÇÓ¢ÎIJ»ºÃµÄ²ËÄñ£¬³ö´íµÄʱºò¶¨Î»´íÎ󣬵«ÊÇÓÐÒ»¸öÎÊÌâ°éËæ³öÏÖ£¬ÎÒÃÇд¹ØÓÚÈÕÆÚµÄsqlµÄÓï¾ä£¬ÎÒÃÇÏëÒªÓ¢ÎĵĸñʽÔõô°ì£¿ÏÂÃæÓÐÁ½¸ö°ì·¨£º
1. Á¬½Óµ½Êý¾Ý¿âºó£¬ÎÒÃÇʹÓÃÈçÏÂÓï¾ä
  ALTER SESSION SET NLS_D ......

oracleÖ§³ÖµÄÊý¾ÝÀàÐÍ

³£ÓõÄÊý¾Ý¿â×Ö¶ÎÀàÐÍÈçÏ£º
×Ö¶ÎÀàÐÍ ÖÐÎÄ˵Ã÷ ÏÞÖÆÌõ¼þ ÆäËü˵Ã÷
CHAR ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
VARCHAR2 ¿É±ä³¤¶ÈµÄ×Ö·û´® ×î´ó³¤¶È4000 bytes ¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
NVARCHAR2 ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´® ×î´ó³¤¶È4000 bytes
DATE È ......

ÅäÖöà¸öSDE·þÎñ(oracle)

ÅäÖöà¸öSDE·þÎñ(oracle)  ÏîĿҪ׼±¸Á½·ÝÏàͬ½á¹¹µÄÊý¾Ý¸ø²»Í¬µÄÓû§£¬ÓÉÓÚÊý¾ÝÁ¿ºÜ´ó£¬²»¶ÏµÄ±¸·Ý»¹Ô­Ð§ÂÊÊ®·ÖµÍÏ£¬Òò´Ë¿¼ÂÇн¨Ò»¸öÊý¾Ý¿â£¬½¨Á¢Á½¸öSDE·þÎñ¡£
1.н¨Êý¾Ý¿âDXGX_GX(Ô­Êý¾Ý¿â£ºDXGX)
2.ÔËÐÐSDE POST д´½¨Ò»¸ö·þÎñ£¨ÔÚ´´½¨Ö®Ç°ÐèÒªÏȹرÕÒÑÔÚÔËÐÐÖеÄSDE·þÎñ£©
3.ÔÚArcCatalogÀィÁ¢ÐµÄSDEÁ¬ ......

MS SQL Server ¡¢Sybase¡¢ OracleÖ§³ÖËø¶¨·½°¸µÄ²»Í¬

»¹ÊǼ¸Î»¶ÁÎÒµÄÊé (¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX UNIXÉϵÄʵսÏê½â¡·) µÄ¶ÁÕßÀ´Óʼþ×ÉѯÎÊÌ⣬ºÜ±§Ç¸ÎÒ²»ÄÜÖðλ»Ø¸´Óʼþ£¬µÚÒ»ÎÒÕæµÄͦ棬µÚ¶þÕâЩÎÊÌâÆÄÓй²ÐÔ¡£ÎÒÀ´½èÖúÕâ¸öµØ·½£¬Í³Ò»µØºÍÖîλ̽ÌÖ£¬ºÜ¶àÎÊÌâÎÒÒ²ÊÇÔÚÃþË÷ÖУ¬²»ÄÜÖ±½Ó¸ø´ó¼Ò´ð°¸£¬ºÇºÇ£¬´ó¼Ò¼ûÁ°¡!

˵˵ËøÎÊÌâ¡£ MS SQLÖ§³ÖµÄËøÀàÐͺÍOracle²îÒìÊǺ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ