Field type |
Describe |
Field length and its default value |
char (size) |
String data used to hold the fixed length (size) byte. |
The length of each line is fixed (the insufficient part is blank), the maximum is 255 bytes, and the default value is 1 bytes per line. |
|
varchar (size) |
Used to save variable-length string data. Where the maximum byte length is specified by (size). |
Each line is variable in length and has a maximum length of 255 bytes. Data length defaults to 1 |
NCHAR (size) |
Multibyte string. |
The length of each line is fixed (the insufficient part is blank). The length (size) refers to the number of characters, the maximum number of bytes is size*[email protected] @nchar size. |
nvarchar (size) |
Variable-length, multibyte-string. |
Each line becomes longer. The length (size) refers to the number of characters, the maximum number of bytes is size*[email protected] @nchar size. |
Binary (size) |
A fixed-length binary string. |
The length of each line is fixed (the insufficient part is blank), the maximum is 255 bytes, and the default value is 1 bytes per line. |
varbinary (size) |
The length of a variable length binary string. |
Each line is variable in length and has a maximum length of 255 bytes. Data length defaults to 1 |
Timestamp |
Used to change the binary value of management. |
The number of bytes is 16 |
Datetime |
Saves fixed-length datetime data ranging from January 1, 1753 to December 21, 9999, with a precision of 3 microsecond intervals. |
Each row is fixed to a length of 8 bytes. |
smalldatetime |
Saves the fixed-length datetime data, ranging from January 1, 1990 to June 6, 2079, with a precision of minute intervals. |
Each row is fixed to a length of 4 bytes. |
Int |
Saves integer data, ranging from 2147483647 to +2147483647. |
The maximum length is 4 bytes 32-1 bytes or 4G. |
smallint |
Save integer data, ranging from 32767 to +32767 |
The maximum length is 2 bytes 32-1 bytes or 4G. |
tinyint |
Saves integer data, ranging from 0 to 255. |
The maximum length is 1 bytes. |
Float |
Saves the floating-point data type, ranging from -2.23E-308 to +2.23E-308. |
The maximum length is 8 bytes. |
Real |
Saves the floating-point data type, ranging from -1.18E-38 to +1.18E-38. |
The maximum length is 4 bytes. |
Numeric (P,s) |
Save exact numeric data type, range -10E-38 to +10e-38,p is precision, total scale (1~38), S is decimal (decimal bit less than equals p) |
The maximum length is 2~17 bytes. |
Decimal (P,s) |
Save exact numeric data type, range -10E-38 to +10e-38,p is precision, total scale (1~38), S is decimal (decimal bit less than equals p) |
The maximum length is 2~17 bytes. |
Money |
Save currency Value data type, range from 922337203685477.5808 to +922337203685477.5808 |
The maximum length is 8 bytes. |
SmallMoney |
Save currency Value data type, range from 214748.3647 to +214748.3647 |
The maximum length is 4 bytes. |
Text |
Save a column larger than 255 bytes or text data that is larger than the 2KB page length. |
The maximum length is 2G. |
Image |
Saves a column greater than 255 bytes or binary data that is larger than the 2KB page length. |
Maximum length |