ýˆ¡Áýˆ©`£¾¤â¤¦Ò»¶È¡¢¥¹¥¿©`¥È£Þ£¦£Þ¡¡

来源: BlogBus 原始链接: http://www.blogbus.com:80/blogbus/blog/index.php?blogid=21065&amp 存档链接: https://web.archive.org/web/20041220154241id_/http://www.blogbus.com:80/blogbus/blog/index.php?blogid=21065&amp

ýˆ¡Áýˆ©£¾¤â¤¦Ò»¶È¡¢¥¹¥¿©¥È£Þ£¦£Þ¡¡ ¼¼Ðg¡¢¥¹¥¿©`¥È Ê×Ò³ ýˆ¤ÎÐÄÇé (3) ýˆ¤ÎÈÕÓ› (3) ýˆ¤ÎÈÕÃÔ (2) ýˆ¤ÎÎÄÕª (2) ýˆ¤Î¼¼Ðg (3) ·ÖÒ³: [1] [2] [3] [4] [5] 2004-11-22 00:35 ½ñÈÕÖ®¹¤×÷ fu,µ÷ÑÐÁËÈýÖÖÄ¿Ç°ËùÓõÄÊý¾Ý¿âµÄÊý¾ÝÀàÐÍ->CyberMagicÊý¾Ý¶ÁÈ¡Ä£¿é- - ×ÊÁϲο¼ Oracle 9i Êý¾ÝÀàÐÍ =>CSDN SQLSERVER Êý¾ÝÀàÐÍ =>SQLSERVER Áª»ú´ÔÊé InterBase Êý¾ÝÀàÐÍ =>InterBase Documentation ÏÂÖÜÒªÕë¶ÔÆäÖÐÊý¾Ý²¿·ÖÍêÉÆÊý¾Ý´æÈ¡Ä£¿é

22ºÅ¼Ç£º¶ÔÊý¾Ý½øÐÐÁ˸ñʽ»¯ÕûÀí ^^ Ethan @ 00:35 | ÔĶÁÈ«ÎÄ | ÆÀÂÛ(1) | ÒýÓÃTrackback(0) | ±à¼­ 2004-11-22 00:21 InterBase Êý¾ÝÀàÐÍ Êý¾ÝÀàÐÍ Êý¾Ý³¤¶ÈºÍ±í´ï·¶Î§ ˵Ã÷ BOOLEAN • ¶¨³¤£¬ 2B • TRUE,FALSE,UNKNOWN • ±í´ïÕæÖµ INTEGER SMALLINT • ¶¨³¤ • ±í´ï·¶Î§ : INTEGER: -2^31 (-2,147,483,648) .. 2^31 - 1 (2,147,483,647) SMALLINT: -2^15 (-32,768).. 2^15 - 1 (32,767) • ±í´ïÕûÐÍÊý¾Ý¡£ DECIMAL(P,S) NUMERIC(P,S) • ±ä³¤ • P: ¾«¶È£¬ 118 S: СÊýλÊý£¬ 018 £¬Ð¡ÓÚ P • ´æ´¢Êý¾ÝÓ뾫¶ÈÓйأ¬¿ÉÒÔΪ 16 £¬ 32 £¬ 64 λ • ´ø¶¨µã¾«¶ÈºÍСÊýλÊýµÄÊý¾ÝÀàÐÍ¡£ • DECIMAL(P,S) ºÍ NUMERIC(P,S) ¹¦ÄÜÏàͬ¡£ FLOAT DOUBLE PRECISION • ¶¨³¤ • ±í´ï·¶Î§ : FLOAT: 1.175 x 10^¨C38 to 3.402 x 10^38 DOUBLE PRECISION: 2.225 x 10^¨C308 to 1.797 x 10^308 • FLOAT ´æ´¢ 32 룬 DOUBLE PRECISION ´æ´¢ 64 λ • IEEE SINGLE ¾«¶ÈΪ 7 λ¡£ • IEEE DOUBLE ¾«¶ÈΪ 15 λ¡£ DATE • ¶¨³¤£¬ 4 ¸ö×Ö½Ú • ±í´ï·¶Î§ : 1 Jan 100 a .d. 1 Jan 100 a .d.to 29 Feb 32768 a .d. µ½ 29 Feb 32768 a .d. • ÒÔ 4 ×Ö½Ú³¤×Ö´æ´¢¡£ TIME • ¶¨³¤£¬ 4 ¸ö×Ö½Ú • ±í´ï·¶Î§ : 0:00 AM µ½ 23:59.9999 PM • ²»´ø·ûºÅµÄÕûÐÍ¡£ TIMESTAMP • ¶¨³¤£¬ 8 ¸ö×Ö½Ú • ±í´ï·¶Î§ : 1 Jan 100 a .d. to 29 Feb 32768 a .d. • ×éºÏ DATE ºÍ TIME ÀàÐÍ¡£ CHAR(N) Subtypes: CHARACTER • ¶¨³¤£¬Îª N ¸ö×Ö½Ú • ×î´ó¸öÊý 32767 ×Ö½Ú • ×Ö·û¼¯µÄ×Ö·û³¤¶ÈÈ·¶¨¿ÉÒÔ´æ·ÅµÄ×Ö·û×î´ó¸öÊý • ¶¨³¤×Ö·û´®£¬ N ×Ö½Ú³¤¡£ • CHARACTER ÊÇ CHAR ͬÒå´Ê¡£ VARCHAR(N) Subtypes: CHAR VARYING CHARACTER VARYING • ±ä³¤ • ×î´ó¸öÊý 32767 ×Ö½Ú • ×Ö·û¼¯µÄ×Ö·û³¤¶ÈÈ·¶¨¿ÉÒÔ´æ·ÅµÄ×Ö·û×î´ó¸öÊý • ±ä³¤×Ö·û´®£¬ N ×Ö½Ú³¤¡£ • • CHAR VARING ºÍ CHARACTER VARING ÊÇ VARCHAR ͬÒå´Ê¡£ Ethan @ 00:21 | ÔĶÁÈ«ÎÄ | ÆÀÂÛ(0) | ÒýÓÃTrackback(0) | ±à¼­ 2004-11-22 00:17 SQL Server Êý¾ÝÀàÐÍ Êý¾ÝÀàÐÍ Êý¾Ý³¤¶ÈºÍ±í´ï·¶Î§ ˵Ã÷ BIGINT INT/INTEGER SMALLINT TINYINT • ¶¨³¤ • ±í´ï·¶Î§ : BIGINT: -2^63 (-9,223,372,036,854,775,808).. 2^63-1 (9,223,372,036,854,775,807) INT: -2^31 (-2,147,483,648) .. 2^31 - 1 (2,147,483,647) SMALLINT: -2^15 (-32,768).. 2^15 - 1 (32,767) TINYINT:0..255 • ±í´ïÕûÐÍÊý¾Ý¡£ • INT ºÍ INTEGER ÊÇͬÒå´Ê£¬ÏÔʾΪ INT ¡£ BIT • ¶¨³¤£¬ 1 ¸ö×Ö½Ú • ±í´ï·¶Î§ :1 or 0 • Ò»¸ö×Ö½Ú´æ´¢µÄÕûÐÎÊý¾Ý£¬Ö»ÄܵÈÓÚ 1 »ò 0 £¬¿ÉÓÃÓÚ±íʾ²¼¶ûÐÍ¡£ DECIMAL(P,S) NUMERIC(P,S) Subtypes: DEC(P,S) DEC • ±ä³¤ • P: ¾«¶È£¬ 138 S: СÊýλÊý£¬ 0P • ´æ´¢Êý¾ÝÓ뾫¶ÈÓÐ¹Ø 19 5B 1019 9B 2028 13B 2938 17B • ´ø¶¨µã¾«¶ÈºÍСÊýλÊýµÄÊý¾ÝÀàÐÍ¡£ • DECIMAL(P,S) ºÍ NUMERIC(P,S) ¹¦ÄÜÏàͬ¡£ • DECIMAL(P,S) ¡¢ DEC(P,S) ºÍ DEC ÊÇͬÒå´Ê£¬ÏÔʾΪ DECIMAL £¬ DEC=DECIMAL(18,0) ¡£ MONEY SMALLMONEY • ¶¨³¤ • ±í´ï·¶Î§ : MONEY: -2^63 (-922,337,203,685,477.5808) .. 2^63 - 1 (+922,337,203,685,477.5807) SMALLMOEY: -214,748.3648 .. +214,748.3647 • »õ±ÒÊýÖµ¡£ • MONEY ¾«È·µ½»õ±Òµ¥Î»µÄǧ·ÖÖ®Ò»£¬ SMALLMONEY ¾«È·µ½»õ±Òµ¥Î»µÄǧ·Ö֮ʮ¡£ FLOAT(N) REAL DOUBLE PRECISION • ¶¨³¤ • N: ¿Æѧ¼ÇÊý·¨ float ÊýβÊýµÄλÊý£¬ 153 • ±í´ï·¶Î§ : -1.79E+ 308..1.79E +308 • ´æ´¢Êý¾ÝÓë N £¨¾«¶È£©ÓÐ¹Ø : 123 4B 24~53 8B • ¸¡µãÊý×ÖÊý¾ÝµÄ½üËÆÊý×ÖÊý¾ÝÀàÐÍ¡£¸¡µãÊý¾ÝΪ½üËÆÖµ£»²¢·ÇÊý¾ÝÀàÐÍ·¶Î§ÄÚµÄËùÓÐÊý¾Ý¶¼Äܾ«È·µØ±íʾ¡£ • FLOAT ĬÈÏ N=53 ¡£ • REAL=FLOAT(23) DOUBLE PRECISION=FLOAT(53) ¡£ • N<24 ÏÔʾΪ REAL £¬ N>=24 ÏÔʾΪ FLOAT ¡£ DATETIME SMALLDATETIME DATETIME • ¶¨³¤£¬ 8 ¸ö×Ö½Ú • ±í´ï·¶Î§ : 1753 Äê 1 Ô 1 ÈÕµ½ 9999 Äê 12 Ô 31 ÈÕµÄÈÕÆÚºÍʱ¼äÊý¾Ý£¬¾«È·µ½°Ù·ÖÖ®ÈýÃ루»ò 3.33 ºÁÃ룩 SMALLDATETIME • ¶¨³¤£¬ 4 ¸ö×Ö½Ú • ±í´ï·¶Î§ : 1900 Äê 1 Ô 1 ÈÕµ½ 2079 Äê 6 Ô 6 ÈÕµÄÈÕÆÚºÍʱ¼äÊý¾Ý£¬¾«È·µ½·ÖÖÓ¡£ • Á½¸ö 4 ×Ö½ÚµÄÕûÊýÄÚ²¿´æ´¢ DATETIME Êý¾ÝÀàÐ͵ÄÖµ¡£µÚÒ»¸ö 4 ×Ö½Ú´æ´¢ base date £¨¼´ 1900 Äê 1 Ô 1 ÈÕ£©Ö®Ç°»òÖ®ºóµÄÌìÊý¡£»ù´¡ÈÕÆÚÊÇϵͳ²Î¿¼ÈÕÆÚ¡£²»ÔÊÐíÔçÓÚ 1753 Äê 1 Ô 1 ÈÕµÄ DATETIME Öµ¡£ÁíÍâÒ»¸ö 4 ×Ö½Ú´æ´¢ÒÔÎçÒ¹ºóºÁÃëÊýËù´ú±íµÄÿÌìµÄʱ¼ä¡£ • SMALLDATETIME Êý¾ÝÀàÐÍ´æ´¢ÈÕÆÚºÍÿÌìµÄʱ¼ä£¬µ«¾«È·¶ÈµÍÓÚ DATETIME ¡£ SQL Server ½« SMALLDATETIME µÄÖµ´æ´¢ÎªÁ½¸ö 2 ×Ö½ÚµÄÕûÊý¡£µÚÒ»¸ö 2 ×Ö½Ú´æ´¢ 1900 Äê 1 Ô 1 ÈÕºóµÄÌìÊý¡£ÁíÍâÒ»¸ö 2 ×Ö½Ú´æ´¢ÎçÒ¹ºóµÄ·ÖÖÓÊý¡£ÈÕÆÚ·¶Î§´Ó 1900 Äê 1 Ô 1 ÈÕµ½ 2079 Äê 6 Ô 6 ÈÕ£¬¾«È·µ½·ÖÖÓ¡£ CHAR(N) NCHAR(N) Subtypes: CHARACTER NATIONAL CHAR NATIONAL CHARACTER • ¶¨³¤£¬Îª N ¸ö×Ö½Ú • CHAR ×î´ó³¤¶È 8000 ×Ö½Ú • NCHAR ×î´ó³¤¶È 4000 ×Ö½Ú • ¶¨³¤×Ö·û´®£¬ N ×Ö½Ú³¤£¬Èç¹û²»Ö¸¶¨³¤¶È£¬È±Ê¡Îª 1 ¸ö×Ö½Ú³¤£¨Ò»¸öºº×ÖΪ 2 ×Ö½Ú£©¡£ • NCHAR ´æ´¢ UNICODE ×Ö·û¼¯µÄ¶¨³¤×Ö·ûÐÍÊý¾Ý¡£ • CHARACTER ÊÇ CHAR ͬÒå´Ê¡£ • NATIONAL CHAR ºÍ NATIONAL CHARACTER ÊÇ NCHAR ͬÒå´Ê¡£ VARCHAR(N) NVARCHAR(N) Subtypes: CHAR VARYING CHARACTER VARYING NATIONAL CHAR VARYING NATIONAL CHARACTER VARYING • ±ä³¤ • VARCHAR ×î´ó³¤¶È 8000 ×Ö½Ú • NVARCHAR ×î´ó³¤¶È 4000 ×Ö½Ú • ³¤¶ÈΪ n ¸ö×ֽڵĿɱ䳤¶ÈµÄ×Ö·ûÊý¾Ý¡£ n ±ØÐëÊÇÒ»¸ö½éÓÚ 1 ºÍ 8,000 Ö®¼äµÄÊýÖµ¡£´æ´¢´óСΪÊäÈëÊý¾ÝµÄ×Ö½ÚµÄʵ¼Ê³¤¶È£¬¶ø²»ÊÇ n ¸ö×Ö½Ú¡£ËùÊäÈëµÄÊý¾Ý×Ö·û³¤¶È¿ÉÒÔΪÁã¡£ • NVARCHAR ´æ´¢ UNICODE ×Ö·û¼¯µÄ±ä³¤×Ö·ûÐÍÊý¾Ý¡£ • CHAR VARING ºÍ CHARACTER VARING ÊÇ VARCHAR ͬÒå´Ê¡£ • NATIONAL CHAR VARING ºÍ NATIONAL CHARACTER VARING ÊÇ NVARCHAR ͬÒå´Ê¡£ TEXT NTEXT Subtypes: NATIONAL TEXT • ±ä³¤ • TEXT ×î´ó³¤¶È 2 31 -1 (2,147,483,647) ¸ö×Ö·û • NTEXT ×î´ó³¤¶È 2 30

• 1 (1,073,741,823) ¸ö×Ö·û Ethan @ 00:17 | ÔĶÁÈ«ÎÄ | ÆÀÂÛ(1) | ÒýÓÃTrackback(0) | ±à¼­ ÈÕÀú 2004 Äê 12 Ô Sun Mon Tue Wen Thu Fri Sat 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 ×î½ü¸üР½ñÈÕÖ®¹¤×÷ InterBase Êý¾ÝÀàÐÍ SQL Server Êý¾ÝÀàÐÍ ÆƱùÖ®×÷..... Oracle Êý¾ÝÀàÐÍ Ã¿ÖÜÈȵ㡫7.14-7.21¡« Inaba Koshi no live Ò»Ìì[Ò»] µ¿ÄîKervin¾ý from wm ji°æ"ºÍÀÏ´óÔÚÒ»Æð" ×îÐÂÆÀÂÛ lakewolf : hi,Сgay¸ç . sql : ¶÷£¬¶¥Ò»Ï£¬ÕýºÃ. ryuryu : ÄãÖÕÓÚ³ÐÈÏÁË£¬ÍÞ. С¹Ë : ÍÛ¹þ¹þ£¬ÎÒϲ»¶±õ. inaba : 178 ganbatte~~~~. ´æµµ ÎÒµÄÁ´½Ó ¶«å­À´·ç japan_idol ÈÕ¹«ÐÅ°ñ oricon ÖíÖí piggy ʲô naniko СÉñ kami Ô¶ù yuete ÅÂÅ pastoral Ã×½ã kotomi