The following is a field type of SQL Server 7.0 or higher. Field Type Description of SQL Server6.5 Please refer to the instructions provided by SQL Server. Bit: 0 or 1 Integer Digital INT: Integer Digital Smallint from -2 ^ 31 (-2, 147, 483, 648) to 2 ^ 31 (2, 147, 483, 647): from -2 ^ 15 (-32, 768) to 2 ^ 15 (32, 767) Integer Digital Tinyint: Total Digital Digital Decimal from 0 to 255: Numeric Numeric: Decimal's Synonym Money: from -2 ^ 63 (-922, 337, 203, 685, 477.5808 ) To 2 ^ 63-1 (922, 337, 203, 685, 477.5807) currency data, minimum currency unit 千 千 s s::: Currency data from -214 ,748.3648 to 214, 748.3647, minimum currency unit thousands of thousands of tens of float: from -1.79e 308 to 1.79e 308 Variable Accuracy Digital Real: Digital DateTime from -3.04E 38 to 3.04E 38 Variable Accuracy: Date and time data from January 1, 9999 to 9999, minimum time unit is Three percent or 3.33 milliseconds SmallDatetime: Date and time data from January 1, 2079, June 6, 2079, Minimum Time Unit for minute TimeStamp: Timestamp, a database width UniqueIndentifier: world unique Identifier Guid Char: Type Data of Unicode, Maximum length of 8000 VARCHAR: The length of Unicode characteristic, the maximum length is 8000 text: the length of the Unicode is determined, the maximum length is 2 ^ 31 -1 (2g) nchar: Type data of Unicode, the maximum length of 8000 nVARCHAR: The maximum length of Unicode is 8000 nText: the maximum length of Unicode is 2 ^ 31- 1 (2g) binary: Decreased binary data, maximum length is 8000 varbinary: becomes long binary data, maximum length is 8000 image: becomes long binary data, the maximum length is 2 ^ 31-1 (2G)
