ASA,ORACLE,SQLSERVER数据类型对照表.xls

SQL 92 Field TypeSYBASE Field Type SQLServer Field TypeOracle Field Type Field TypeField Type Descript ion Field Length and Default Value Field TypeField Type Character typeCharacter typeCharacter typeCharacter type characterchar n used to store fixed n length string data Fixed length fille d the rest with space ma x length is equivalent to the size of page but less than 8K and default is 1 character char n char n character varyingvarchar n used to store variable n length string data Variable length ma x length is equalent to size of page but less than 8K and default is 1 character varchar n varchar n varchar2 n nchar n used to store fixed n n charsize length string data Fixed length fille d the rest with space ma x length is equivalent to the size of page but less than 8K and default is 1 character I n fact the physical character nchar size n N AN A nvarchar n used to store variable n n charsize length string data Variable length ma x length is equivalent to the size of page but less than 8K and default is 1 character I n fact the physical character nchar size n N AN A national characterunichar n used to store fixed Unicode charact er 2 nchar size length string data Fixed length fille d the rest with space ma x length is equivalent to the size of page but less than 8K and default is 1 character I n fact the physical character n 2 nchar n nchar n national character varyingunivarchar n used to store variable Unicode charact er 2 nchar size length string data Variable length ma x length is equivalent to the size of page but less than 8K and default is 1 character I n fact the physical character 2 n nvarchar n nvarchar n Date Time typeDate Time typeDate Time typeDate Time type rowversiontimestampvarbinar y 8 NULL i t is user define data type the fixed length is 8 bytes timestamptimestamp datetimestore datetim e data Ra nge 1753 01 01 999 9 12 21 interval is 3ms the fixed length is 8 bytes datetimedate smalldatetimestore datetim e data Ra nge 1900 01 01 207 9 06 06 interval is 1 minute the fixed length is 4 bytes smalldatetime date 12 5 1 new feature 0001 01 01 to 9999 12 31 the fixed length is 4 bytes N A time 12 5 1 new feature 12 00 0 0AM to 11 59 5 9 59 99 9PM the fixed length is 4 bytes N A Int typeInt typeInt typeInt type integerintstore the integer data ran ge is 2147483 647 2147483 647 Max length is 4 character intnumber smallintstore the integer data ran ge is 32767 32767 Max length is 2 character smallint tinyintstore the integer data ran ge is 0 255 Max length is 1 character tinyint N Abigint Decimal typeDecimal typeDecimal typeDecimal type numeric p s store numeric data with fixed precisio n and scale range 10E 38 10 E 38 p is precisio n total decimal digits 1 38 s is decimal flag s p max length is 2 17 character the unique difference between numeric and decimal is that numeric n 0 can be used at IDENTITY column numeric p s number decdecimal p s store numeric data with fixed precisio n and scale range 10E 38 10 E 38 p is precisio n total decimal digits 1 38 s is decimal flag s p max length is 2 17 character decimal p s double precisionit is based on operate system max length is 8 character double precision float n n 8 15 double precision floatit is based on operate system max length is 4 8 character float float n n 1 7realit is based on operate system max length is 4 character real Money typeMoney typeMoney typeMoney type moneythe range is 2 63 922 337 203 68 5 477 5 808 2 63 1 922 337 203 685 47 7 5807 max length is 8 character moneyN A smallmoneythe range is 214748 3647 214748 3647 max length is 4 character smallmoneyN A Other typeOther typeOther typeOther type textused to store variable n length string data it is multiple of 2K max length is 2G textclob nation textN Antextnclob N AN Abfile imageused to store variable n length binary data it is multiple of 2K max length is 2G imageblob binary n used to store fixed n length binary data Fixed length fille d the rest with space ma x length is equivalent to the size of page but less than 8K and default is 1 character binary n binary varyingvarbinary n used to store variable n length binary data Variable length ma x length is equivalent to the size of page but less than 8K and default is 1 character varbinary n row long row bit0 1Max length is 1 character i t can t be NULL value bitN A Description Field Length and Default Value used to store fixed n length string data non Unicode Fixed length filled the rest with space max length is 2000 byte and default is 1 byte used to store variable n length string data non Unicode Variable length max length is 4000 byte and default is 1 byte used to store fixed Unicode character string data The maximum length of an NCHAR column is 2000 bytes It can hold up to 2000 characters The actual data is subject to the maximum byte limit of 2000 used to store variable Unicode character string data The maximum length of an NVARCHAR2 column is 4000 bytes It can hold up to 4000 characters The actual data is subject to the maximum byte limit of 4000 TIMESTAMP WITH LOCAL TIME ZONE is stored in the database time zone When a user selects the data the value is adjusted to the user s session time zone The DATE datatype stores point in time values dates and times in a table The DATE datatype stores the year including the century the month the day the hours the minutes and the seconds after midnight 1 Positive numbers in the range 1 x 10 130 to 9 99 9 x 10125 with up to 38 significant digits 2 Negative numbers from 1 x 10 130 to 9 99 99 x 10125 with up to 38 significant digits 3 Zero 4 Positive and negative infinity generated only by importing from an Oracle Version 5 database 1 Positive numbers in the range 1 x 10 130 to 9 99 9 x 10125 with up to 38 significant digits 2 Negative numbers from 1 x 10 130 to 9 99 99 x 10125 with up to 38 significant digits 3 Zero 4 Positive and negative infinity generated only by importing from an Oracle Version 5 database Oracle Field Type Character typ