This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
data-types [2015/10/26 13:03] dmtolpeko [Data Types] |
data-types [2016/01/20 09:31] dmtolpeko [Data Type Conversion] |
||
---|---|---|---|
Line 43: | Line 43: | ||
| BIT | TINYINT | | | BIT | TINYINT | | ||
| DATETIME | TIMESTAMP | | | DATETIME | TIMESTAMP | | ||
+ | | INT(n) | INT | | ||
| NCHAR(n) | STRING | | | NCHAR(n) | STRING | | ||
| NVARCHAR(n) | STRING | | | NVARCHAR(n) | STRING | | ||
| NUMBER(p,s) | DECIMAL(p,s) | | | NUMBER(p,s) | DECIMAL(p,s) | | ||
| NUMERIC(p,s) | DECIMAL(p,s) | | | NUMERIC(p,s) | DECIMAL(p,s) | | ||
+ | | TEXT | STRING | | ||
| VARCHAR(MAX) | STRING | | | VARCHAR(MAX) | STRING | | ||
| VARCHAR2(n) | STRING | | | VARCHAR2(n) | STRING | |