SQLite의 데이터 타입입니다.
|
SQLite: Data Types |
||
|
Data Types |
Data Type Syntax |
Explanation |
|
String Datatypes |
CHAR(size) |
Equivalent to TEXT (size is ignored) |
|
VARCHAR(size) |
Equivalent to TEXT (size is ignored) |
|
|
TINYTEXT(size) |
Equivalent to TEXT (size is ignored) |
|
|
TEXT(size) |
Equivalent to TEXT (size is ignored) |
|
|
MEDIUMTEXT(size) |
Equivalent to TEXT (size is ignored) |
|
|
LONGTEXT(size) |
Equivalent to TEXT (size is ignored) |
|
|
NCHAR(size) |
Equivalent to TEXT (size is ignored) |
|
|
NVARCHAR(size) |
Equivalent to TEXT (size is ignored) |
|
|
CLOB(size) |
Equivalent to TEXT (size is ignored) |
|
|
Data Types |
Data Type Syntax |
Explanation |
|
Numeric Datatypes |
TINYINT |
Equivalent to INTEGER |
|
SMALLINT |
Equivalent to INTEGER |
|
|
MEDIUMINT |
Equivalent to INTEGER |
|
|
INT |
Equivalent to INTEGER |
|
|
INTEGER |
Equivalent to INTEGER |
|
|
BIGINT |
Equivalent to INTEGER |
|
|
INT2 |
Equivalent to INTEGER |
|
|
INT4 |
Equivalent to INTEGER |
|
|
INT8 |
Equivalent to INTEGER |
|
|
NUMERIC |
Equivalent to NUMERIC |
|
|
DECIMAL |
Equivalent to NUMERIC |
|
|
REAL |
Equivalent to REAL |
|
|
DOUBLE |
Equivalent to REAL |
|
|
DOUBLE PRECISION |
Equivalent to REAL |
|
|
FLOAT |
Equivalent to REAL |
|
|
BOOLEAN |
Equivalent to NUMERIC |
|
|
Data Types |
Data Type Syntax |
Explanation |
|
Date/Time Datatypes |
DATE |
Equivalent to NUMERIC |
|
DATETIME |
Equivalent to NUMERIC |
|
|
TIMESTAMP |
Equivalent to NUMERIC |
|
|
TIME |
Equivalent to NUMERIC |
|
|
Data Types |
Data Type Syntax |
Explanation |
|
Large Object (LOB) Datatypes |
BLOB |
Equivalent to NONE |
