Lists of SQL Data Type
::: warning
Each SQL language have different data types. Some have more, some have less.
Make sure you read the documentation first
:::
Basic Data Type
| Data type | Description |
|---|---|
CHARCHAR(size) | Holds a fixed length string. The fixed size is specified in parenthesis. Can store up to 255 characters |
VARCHARVARCHAR(size) | Holds a variable length string. The maximum size is specified in parenthesis. Can store up to 255 characters. |
TEXTTEXT | Holds a string with a maximum length of 65,535 characters |
ENUMENUM(x,y,z,etc.) | Let you enter a list of possible values. You can list up to 65,535 values in an ENUM list. If a value is inserted that is not in the list, a blank value will be inserted. |
INTINT | |
DECIMALDECIMAL(precision, scale) | |
FLOATFLOAT(precision, scale) | |
DOUBLEDOUBLE(precision, scale) | |
BOOLEANBOOLEAN | |
DATEDATE | |
DATETIMEDATETIME |
Note: The values are sorted in the order you enter them.