그거/Java
MSSQL의 JDBC 로의 컬럼 타입 매핑
뽀기
2011. 8. 8. 14:18
MSSQL : JDBC
-------------------------------+----------------
char, nchar : CHAR
varchar, nvarchar : VARCHAR
text, ntext : LONGVARCHAR
binary, timestamp : BINARY
varbinary : VARBINARY
image, udt : LONGVARBINARY
bit : BIT
tinyint : TINYINT
smallint : SMALLINT
int : INTEGER
bigint : BIGINT
numeric : NUMERIC
decimal, money, smallmoney : DECIMAL
real : REAL
double, float : DOUBLE
datetime, smalldatetime : TIMESTAMP