ODBC에서 DB와 서버랑 맵핑하는 자료형 정리

ODBC에서 DB와 서버랑 맵핑하는 자료형 정리

Table 1. C vs ODBC Naming Correspondence

C Type identifier	ODBC C Typedef	C Type
SQL_C_CHAR	SQLCHAR	unsigned char
SQL_C_STINYINT	SCHAR	char
SQL_C_UTINYINT [i]	UCHAR	unsigned char
SQL_C_SSHORT [h]	SQLSMALLINT	short int
SQL_C_USHORT [h] [i]	SQLUSMALLINT	unsigned short int
SQL_C_SLONG [h]	SQLINTEGER	int
SQL_C_ULONG [h] [i]	SQLUINTEGER	unsigned int
SQL_C_SBIGINT	SQLBIGINT	_int64 [g]
SQL_C_UBIGINT [i]	SQLUBIGINT	unsigned _int64 [g] solidDB does not support unsigned data types such as this.
SQL_C_FLOAT	SQLREAL	float
SQL_C_DOUBLE	SQLDOUBLE SQLFLOAT	double
SQL_C_NUMERIC	SQLNUMERIC	unsigned char [f]
SQL_C_DECIMAL	SQLDECIMAL	unsigned char [f]
SQL_C_BINARY	SQLCHAR *	unsigned char *
SQL_C_TYPE_DATE [c]	SQL_DATE_STRUCT	struct tagDATE_STRUCT{ SQLSMALLINT year; SQLUSMALLINT month; SQLUSMALLINT day; } DATE_STRUCT; [a]
SQL_C_TYPE_TIME [c]	SQL_TIME_STRUCT	struct tagTIME_STRUCT { SQLUSMALLINT hour; SQLUSMALLINT minute;[d] SQLUSMALLINT second;[e] }
SQL_C_TYPE_TIMESTAMP [c]	SQL_TIMESTAMP_STRUCT	struct tagTIMESTAMP_STRUCT { SQLSMALLINT year; [a] SQLUSMALLINT month; [b] SQLUSMALLINT day; [c] SQLUSMALLINT hour; SQLUSMALLINT minute; [d] SQLUSMALLINT second;[e] SQLUINTEGER fraction; }

원본링크