¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ç¡¼¥¿·¿°ìÍ÷
£°¡¥¹¹¿·ÍúÎò
- 2002.05.15¡¡¿·µ¬ºîÀ®
- 2002.09.06¡¡¾ÜºÙÀâÌÀ¤ÎÄɲÃ
- 2005.06.09¡¡MySQL¤ÎÄɲÃ
£±¡¥¤Ï¤¸¤á¤Ë
¡¡¤³¤Î¥É¥¥å¥á¥ó¥È¤Ç¤Ï¡¤¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ç¡¼¥¿·¿¤Ë¤Ä¤¤¤ÆÀâÌÀ¤¹¤ë¡¥
£²¡¥Sybase¤Î¾ì¹ç¡Ê11.x¤¯¤é¤¤¤Þ¤Ç¡Ë
| ·¿ | ɽ¸½ÈÏ°Ï | ¥³¥á¥ó¥È | |
|---|---|---|---|
| ¤è¤¯¤Ä¤«¤¤¤½¤¦ | numeric(p,s) | 38·å | p¤Ï38·å¤Þ¤Ç¤Î°Ì¼è¤ê¤¬²Äǽ¡¥ s¤Ï¤¦¤Á¿ô¡¥ |
| char(n) | 255byte. | ¥·¥ó¥°¥ë¥Ð¥¤¥È | |
| nchar(n) | 255byte. | ÆüËܸì¤Ê¤É¤Î¥Þ¥ë¥Á¥Ð¥¤¥Èʸ»ú¤òÊݸ¤¹¤ë¡¥ | |
| text | 2GB | ||
| datetime | 1753ǯ¡Á9999ǯ | ||
| varchar(n) | 255byte. | ÆüËܸì¤À¤È127ʸ»ú¤Þ¤Ç¡¥ | |
| nvarchar(n) | 255byte. | ÆüËܸì¤À¤È127ʸ»ú¤Þ¤Ç¡¥ | |
| binary(n) | 255byte. | 255byte | |
| image | 2GB | ||
| ¤¢¤Þ¤ê¤Ä¤«¤ï¤Ê¤½¤¦ | tinyint | 0-255 | |
| smallint | -32768¡Á32767 | ||
| int | 31·å | 31·å | |
| decimal(p,s) | 38·å | numeric¤ÈƱ¤¸¡¥ ANSIɸ½à¤Î¤¿¤á¤Ë¤¢¤ë¡¥ | |
| float(p) | µ¡¼ï°Í¸ | ||
| double precision | µ¡¼ï°Í¸ | ||
| real | µ¡¼ï°Í¸ | ||
| money | 15.4·å | ͸úɽ¸½14·å¡¥ | |
| smallmoney | 6.4·å¡¥ | ͸úɽ¸½5·å | |
| smalldate | 1900ǯ¡Á2076ǯ | ||
| bit | 0 or 1 |
¡¡´ðËÜŪ¤Ë¤¢¤Þ¤êÊѤï¤ê¤Ï̵¤¤¤È»×¤¦¤±¤É¡¤12.5¤¯¤é¤¤¤«¤é¾¤Î¥Ç¡¼¥¿·¿¤¬Äɲ䵤ì¤Æ¤½¤¦¤Êµ¤¤¬¤¹¤ë¡¥
£³¡¥Oracle¤Î¾ì¹ç¡Ê8i¤¯¤é¤¤¤Þ¤Ç¡Ë
| ·¿ | ɽ¸½ÈÏ°Ï | ¥³¥á¥ó¥È | ||
|---|---|---|---|---|
| ¤è¤¯¤Ä¤«¤¤¤½¤¦ | CHAR(n) | ¸ÇÄêĹ ʸ»úÎó |
2000byte. | Oracle7¤Ç¤Ï256byte. ̤»ÈÍÑÉôʬ¤Ï¶õÇò¤ò¤¤¤ì¤ë¡¥ |
| VARCHAR2(n) | ²ÄÊÑĹ ʸ»úÎó |
4000byte | ²ÄÊÑĹʸ»úÎó¡¥¥·¥ó¥°¥ë¥Ð¥¤¥È¡¥ | |
| LONG | ²ÄÊÑĹ ʸ»úÎó |
2GByte. | 1¤Ä¤Îɽ¤Ë£±¤Ä¤Þ¤Ç¡¥ ¾ò·ï(Where,Group by)¤Ç»È¤¨¤Ê¤¤¡¥ ¥Ç¡¼¥¿¤ò¹ÔÆâ¤Ë³ÊǼ¤¹¤ë¡¥ ¸¡º÷»þ¤Ë¥Ç¡¼¥¿¤òÊÖ¤¹¡¥ |
|
| NUMBER(p,s) | ¿ôÃÍ·¿ | 38·å | p¤Ï38·å¤Þ¤Ç¤Î°Ì¼è¤ê¤¬²Äǽ¡¥ s¤Ï¤¦¤Á¿ô¡¥ | |
| DATE | ÆüÉÕ»þ¹ï·¿ | ǯ·îÆü»þʬÉäò³ÊǼ¤Ç¤¤ë¡¥ | ||
| LONG RAW | ²ÄÊÑĹ ¥Ð¥¤¥Ê¥ê¡¼ |
2GByte. | 1¤Ä¤Îɽ¤Ë£±¤Ä¤Þ¤Ç¡¥ ¾ò·ï(Where,Group by)¤Ç»È¤¨¤Ê¤¤¡¥ ¥Ç¡¼¥¿¤ò¹ÔÆâ¤Ë³ÊǼ¤¹¤ë¡¥ ¸¡º÷»þ¤Ë¥Ç¡¼¥¿¤òÊÖ¤¹¡¥ |
|
| NCHAR | ¸ÇÄêĹ ʸ»úÎó |
2000byte. | ̤»ÈÍÑÉôʬ¤Ï¶õÇò¤ò¤¤¤ì¤ë¡¥ | |
| NVARCHAR2 | ²ÄÊÑĹ ʸ»úÎó |
4000byte¤Þ¤Ç¡¥ | ¥Þ¥ë¥Á¥Ð¥¤¥È¡¥ | |
| BLOB | ²ÄÊÑĹ ¥Ð¥¤¥Ê¥ê¡¼ |
4G | ¥Ð¥¤¥Ê¥ê¡¥ | |
| NCLOB | ²ÄÊÑĹ ʸ»úÎó |
4G | ¥Þ¥ë¥Á¥Ð¥¤¥È¡¦¥Æ¥¥¹¥È¡¥ £±¤Ä¤Îɽ¤ËÊ£¿ô¹Ô¡¥(8i¤È9i¤Ç¤Ï1000) 4000¥Ð¥¤¥È°Ê¾å¤Ë¤Ê¤ë¾ì¹ç¡¤¹Ô¤Î³°¤Ë³ÊǼ¡¥ ¸¡º÷»þ¤Ë¥í¥±¡¼¥¿¤òÊֵѡ¥ |
|
| ¤¢¤Þ¤ê¤Ä¤«¤ï¤Ê¤½¤¦¡© | VARCHAR | ¸ÇÄêĹ ʸ»úÎó |
VARCHAR2¤ÈƱ¤¸¡¥¡¡Oracle6¤È¤Î¸ß´¹À¤Î¤¿¤á¤Ë¤¢¤ë¡¥¡¡2000byte¤«¤â¡© | |
| RAW(s) | ²ÄÊÑĹ ¥Ð¥¤¥Ê¥ê¡¼ |
2000¥Ð¥¤¥È¤Þ¤Ç²Äǽ¡¥ | Oracle7¤Ç¤Ï256byte. | |
| CLOB | ²ÄÊÑĹ ʸ»úÎó |
4G | ¥·¥ó¥°¥ë¥Ð¥¤¥È¤Î¥Æ¥¥¹¥È | |
| BFILE | ¥Õ¥¡¥¤¥ë ¥Ý¥¤¥ó¥¿ |
2G | ÆɼèÀìÍÑ.OS¥Õ¥¡¥¤¥ë¤Ë¥¢¥¯¥»¥¹²Äǽ¡¥ |
¡¡Oracle9i¤Ç¤Ï¡¤timestamp·Á¤È¤¤¤¦¤Î¤¬Äɲ䵤줿¤é¤·¤±¤É¡¥
£´¡¥MySQL 4.x¤Î¾ì¹ç
| ·¿ | ɽ¸½ÈÏ°Ï | ¥³¥á¥ó¥È | |
|---|---|---|---|
| ʸ»ú´ØÏ¢ | date | '1000-01-01' ¡Á '9999-12-31' | 'YYYY-MM-DD' ·Á¼°¤Çɽ¼¨ |
| datetime | 1000-01-01 00:00:00' ¡Á '9999-12-31 23:59:59 | 'YYYY-MM-DD HH:MM:SS' ·Á¼°¤Çɽ¼¨ | |
| timestamp | 1970-01-01 00:00:00' ¡Á 2037 ǯ | Ãͤγä¤êÅö¤Æ¤Ë¤Ïʸ»úÎó¤Þ¤¿¤Ï¿ôÃͤΤ¤¤º¤ì¤«¤ò»ÈÍÑ.
MySQL 4.1 °Ê¹ß¤Ç¤Ï¡¢TIMESTAMP ¤Ï 'YYYY-MM-DD HH:MM:SS' |
|
| time | -838:59:59' ¡Á '838:59:59' | 'HH:MM:SS' ·Á¼°¤Çɽ¼¨ | |
| year | 4 ·å·Á¼°¤Ç¤Ï 1901 ¡Á 2155 ¤È 0000¡¢2 ·å·Á¼°¤Ç¤Ï 1970 ¡Á 2069¡Ê70 ¡Á 69¡Ë | ||
CHAR |
0¡Á255ʸ»ú | ¥Ð¡¼¥¸¥ç¥ó 4.1.0 °Ê¹ß¤Ç¤Ï¡¢255 ¤è¤êÂ礤¤ M Ãͤò»ØÄꤹ¤ë¤È¡¢¥«¥é¥à·¿¤¬ TEXT ·¿¤ËÊÑ´¹¡¥ | |
varchar |
0¡Á255ʸ»ú | ||
| tinyblob,tinytext | 255¡Ê2^8 - 1¡Ë | ||
| blob,text | 65535¡Ê2^16 - 1¡Ë | ||
| MEDIUMBLOB , MEDIUMTEXT | 16777215¡Ê2^24 - 1¡Ëʸ»ú | ||
| LONGBLOB , LONGTEXT |
ºÇÂ獬 4294967295 ¤Þ¤¿¤Ï 4G¡Ê2^32 - 1¡Ë | ||
| ENUM | |||
| SET | |||
| ¿ôÃÍ´Ø·¸ | tinyint | -128¡Á127 | Éä¹æ̵¤·¤Ï0¡Á255 |
| smallint | -32768¡Á32767 | Éä¹æ̵¤·0¡Á65535 | |
| int | -2147483648 ¡Á 2147483647 | 31·å | |
| mediumint | -8388608 ¡Á 8388607 | Éä¹æ̵¤·0 ¡Á 16777215 | |
| integer | -2147483648 ¡Á 2147483647 | int¤ÈƱ¤¸ | |
| bigint | -9223372036854775808 ¡Á 9223372036854775807¡/td> | Éä¹æ̵¤·0 ¡Á 18446744073709551615 bigint·¿¤Ë´Ø¤·¤Æ¤ÏÀÀÌ󤬤¢¤ë¤Î¤Ç¥Þ¥Ë¥å¥¢¥ë¤ò»²¾È¤Î»ö¡¥ |
|
| float(precision) | ODBC¤È¤Î¸ß´¹À¤Î°Ù¤Ë¤¢¤ë¡¥¤³¤Î·¿¤Ë´Ø¤·¤Æ¤ÏÀÀÌ󤬤¢¤ë¤Î¤Ç¥Þ¥Ë¥å¥¢¥ë¤ò»²¾È¤Î»ö¡¥ | ||
| float(·å¿ô¡¤¾®¿ôÅÀ·å¿ô) double precision(·å¿ô¡¤¾®¿ôÅÀ·å¿ô) real(·å¿ô¡¤¾®¿ôÅÀ·å¿ô) |
-3.402823466E+38 ¡Á -1.175494351E-38 | -3.402823466E+38 ¡Á -1.175494351E-38 | |
| decimal(·å¿ô¡¤¾®¿ôÅÀ·å¿ô) dec(·å¿ô¡¤¾®¿ôÅÀ·å¿ô) numeric(·å¿ô¡¤¾®¿ôÅÀ·å¿ô) fixed(·å¿ô¡¤¾®¿ôÅÀ·å¿ô) |
double¤ÈƱ¤¸ | ||
| bit,bool,boolean | 0 or 1 | tinyint(1)¤ÎÊÌ̾¡¥ | |
¤´»²¹Í
- KB
- 11973¡¡Oracle8¤Î¥Ç¡¼¥¿·¿¤ÎÀ©¸ÂÃÍ¡¡
- 41962¡¡[Oracle9i] ÆüÉեǡ¼¥¿·¿¤Î¼ïÎà
