Field Type |
Description |
Field Length and default value |
Char (size) |
It is used to save string data of a fixed length (size) byte. |
Fill in space for less than the fixed length of each line). The maximum length is 254 bytes. The default value is 1 byte for each line. |
Varchar (size) |
Used to save variable-length string data. The maximum byte length is specified by (size. |
The length of each line is variable. The maximum length is 254 bytes. The default data length is 1. |
Serial |
Automatic growth type. |
Storage by Integer type. |
Nchar (size) |
Double-byte string. |
Fill in spaces for the remaining fixed length of each line ). Length (size) refers to the number of characters, the maximum number of bytes is 254*2. |
Nvarchar (size) |
Variable Length, double-byte string. |
Each line gets longer. Length (size) refers to the number of characters, the maximum number of bytes is size * 2. |
Real |
Save the floating point data type. The value range is-2.23E-308 to + 2.23E-308. |
The maximum length is 8 bytes. |
Interval |
Specifies a time span. |
5-3) year to month, (11: 15) hour to minute. |
Date |
Date type. |
Each row is fixed to 10 bytes in length. |
Datetime |
Date and Time type. |
Each line is fixed to 8 bytes in length. |
Integer |
Stores integer data in the range of-2147483648 to + 2147483647. |
The maximum length is 4 bytes 32-1 bytes or 4 GB. |
Smallint |
Stores integer data in the range of-32768 to + 32767. |
The maximum length is 2 bytes 32-1 bytes or 4 GB. |
Float |
Save the floating point data type. The value range is-2.23E-308 to + 2.23E-308. |
The maximum length is 8 bytes. |
Smallfloat |
Save the floating point data type. The value range is-2.23E-308 to + 2.23E-308. |
The maximum length is 8 bytes. |
Money (p, s) |
The data type of the exact value is saved. The value range is-10E-38 to + 10E-38. p indicates the precision and the total decimal places (1 ~ 38), s is the decimal point (decimal point less than or equal to p) |
The maximum length is 2 ~ 17 bytes. |
Decimal (p, s) |
The data type of the exact value is saved. The value range is-10E-38 to + 10E-38. p indicates the precision and the total decimal places (1 ~ 38), s is the decimal point (decimal point less than or equal to p) |
The maximum length is 2 ~ 17 bytes. |
Text |
Save text data within 2 GB. |
The maximum length is 2 GB. |
Byte |
Saves binary data within 2 GB. |
The maximum length is 2 GB. |