data-types
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
data-types [2016/03/10 16:40] dmtolpeko |
data-types [2016/03/10 16:45] dmtolpeko [Data Type Conversion] |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| | BINARY_DOUBLE ||| Double precision floating-point number | | | BINARY_DOUBLE ||| Double precision floating-point number | | ||
| | BINARY_FLOAT ||| Single precision floating-point number | | | BINARY_FLOAT ||| Single precision floating-point number | | ||
| - | | BINARY_INTEGER | INT 8 | 32-bit integer | | + | | BINARY_INTEGER ||| 32-bit integer | |
| | BIT ||| 0, 1 or NULL | | | BIT ||| 0, 1 or NULL | | ||
| | BOOL | BOOLEAN || True or false | | | BOOL | BOOLEAN || True or false | | ||
| Line 45: | Line 45: | ||
| | DATETIME | TIMESTAMP | | | DATETIME | TIMESTAMP | | ||
| | INT(n) | INT | | | INT(n) | INT | | ||
| + | | INT2 | SMALLINT | | ||
| + | | INT4 | INT | | ||
| + | | INT8 | BIGINT | | ||
| | NCHAR(n) | STRING | | | NCHAR(n) | STRING | | ||
| | NVARCHAR(n) | STRING | | | NVARCHAR(n) | STRING | | ||
Page Tools
