view release on metacpan or  search on metacpan

sqlext.h  view on Meta::CPAN

#define SQL_BINARY				(-2)
#define SQL_VARBINARY				(-3)
#define SQL_LONGVARBINARY			(-4)
#define SQL_BIGINT				(-5)
#define SQL_TINYINT 				(-6)
#define SQL_BIT 				(-7)
#if (ODBCVER >= 0x0350)
#define SQL_GUID				(-11)
#endif	/* ODBCVER >= 0x0350 */


/*
 *  SQL Interval datatypes
 */
#if (ODBCVER >= 0x0300)
#define SQL_CODE_YEAR				1
#define SQL_CODE_MONTH				2
#define SQL_CODE_DAY				3
#define SQL_CODE_HOUR				4
#define SQL_CODE_MINUTE				5
#define SQL_CODE_SECOND				6
#define SQL_CODE_YEAR_TO_MONTH			7
#define SQL_CODE_DAY_TO_HOUR			8
#define SQL_CODE_DAY_TO_MINUTE			9
#define SQL_CODE_DAY_TO_SECOND			10
#define SQL_CODE_HOUR_TO_MINUTE			11
#define SQL_CODE_HOUR_TO_SECOND			12
#define SQL_CODE_MINUTE_TO_SECOND		13

#define SQL_INTERVAL_YEAR			(100 + SQL_CODE_YEAR)
#define SQL_INTERVAL_MONTH			(100 + SQL_CODE_MONTH)
#define SQL_INTERVAL_DAY			(100 + SQL_CODE_DAY)
#define SQL_INTERVAL_HOUR			(100 + SQL_CODE_HOUR)
#define SQL_INTERVAL_MINUTE			(100 + SQL_CODE_MINUTE)
#define SQL_INTERVAL_SECOND                	(100 + SQL_CODE_SECOND)
#define SQL_INTERVAL_YEAR_TO_MONTH		(100 + SQL_CODE_YEAR_TO_MONTH)
#define SQL_INTERVAL_DAY_TO_HOUR		(100 + SQL_CODE_DAY_TO_HOUR)
#define SQL_INTERVAL_DAY_TO_MINUTE		(100 + SQL_CODE_DAY_TO_MINUTE)
#define SQL_INTERVAL_DAY_TO_SECOND		(100 + SQL_CODE_DAY_TO_SECOND)
#define SQL_INTERVAL_HOUR_TO_MINUTE		(100 + SQL_CODE_HOUR_TO_MINUTE)
#define SQL_INTERVAL_HOUR_TO_SECOND		(100 + SQL_CODE_HOUR_TO_SECOND)
#define SQL_INTERVAL_MINUTE_TO_SECOND		(100 + SQL_CODE_MINUTE_TO_SECOND)
#else
#define SQL_INTERVAL_YEAR			(-80)
#define SQL_INTERVAL_MONTH			(-81)
#define SQL_INTERVAL_YEAR_TO_MONTH		(-82)
#define SQL_INTERVAL_DAY			(-83)
#define SQL_INTERVAL_HOUR			(-84)
#define SQL_INTERVAL_MINUTE			(-85)
#define SQL_INTERVAL_SECOND			(-86)
#define SQL_INTERVAL_DAY_TO_HOUR		(-87)
#define SQL_INTERVAL_DAY_TO_MINUTE		(-88)
#define SQL_INTERVAL_DAY_TO_SECOND		(-89)
#define SQL_INTERVAL_HOUR_TO_MINUTE		(-90)
#define SQL_INTERVAL_HOUR_TO_SECOND		(-91)
#define SQL_INTERVAL_MINUTE_TO_SECOND		(-92)
#endif	/* ODBCVER >= 0x0300 */


/*
 *   SQL unicode data types
 */
#if (ODBCVER <= 0x0300)
/* These definitions are historical and obsolete */
#define SQL_UNICODE				(-95)
#define SQL_UNICODE_VARCHAR			(-96)
#define SQL_UNICODE_LONGVARCHAR			(-97)
#define SQL_UNICODE_CHAR			SQL_UNICODE
#else
#define SQL_UNICODE				SQL_WCHAR
#define SQL_UNICODE_VARCHAR			SQL_WVARCHAR
#define SQL_UNICODE_LONGVARCHAR			SQL_WLONGVARCHAR
#define SQL_UNICODE_CHAR			SQL_WCHAR
#endif	/* ODBCVER >= 0x0300 */


#if (ODBCVER < 0x0300)
#define SQL_TYPE_DRIVER_START			SQL_INTERVAL_YEAR
#define SQL_TYPE_DRIVER_END			SQL_UNICODE_LONGVARCHAR
#endif	/* ODBCVER < 0x0300 */


#define SQL_SIGNED_OFFSET			(-20)
#define SQL_UNSIGNED_OFFSET			(-22)


/*
 *  C datatype to SQL datatype mapping
 */
#define SQL_C_CHAR    				SQL_CHAR
#define SQL_C_LONG    				SQL_INTEGER
#define SQL_C_SHORT   				SQL_SMALLINT
#define SQL_C_FLOAT   				SQL_REAL
#define SQL_C_DOUBLE  				SQL_DOUBLE
#if (ODBCVER >= 0x0300)
#define SQL_C_NUMERIC				SQL_NUMERIC
#endif	 /* ODBCVER >= 0x0300 */
#define SQL_C_DEFAULT 				99


#define SQL_C_DATE				SQL_DATE
#define SQL_C_TIME				SQL_TIME
#define SQL_C_TIMESTAMP 			SQL_TIMESTAMP
#define SQL_C_BINARY				SQL_BINARY
#define SQL_C_BIT				SQL_BIT
#define SQL_C_TINYINT				SQL_TINYINT
#define SQL_C_SLONG 				(SQL_C_LONG+SQL_SIGNED_OFFSET)
#define SQL_C_SSHORT				(SQL_C_SHORT+SQL_SIGNED_OFFSET)
#define SQL_C_STINYINT				(SQL_TINYINT+SQL_SIGNED_OFFSET)
#define SQL_C_ULONG 				(SQL_C_LONG+SQL_UNSIGNED_OFFSET)
#define SQL_C_USHORT				(SQL_C_SHORT+SQL_UNSIGNED_OFFSET)
#define SQL_C_UTINYINT				(SQL_TINYINT+SQL_UNSIGNED_OFFSET)
#define SQL_C_BOOKMARK				SQL_C_ULONG

#if (ODBCVER >= 0x0300)
#define SQL_C_TYPE_DATE				SQL_TYPE_DATE
#define SQL_C_TYPE_TIME				SQL_TYPE_TIME
#define SQL_C_TYPE_TIMESTAMP			SQL_TYPE_TIMESTAMP
#define SQL_C_INTERVAL_YEAR			SQL_INTERVAL_YEAR
#define SQL_C_INTERVAL_MONTH			SQL_INTERVAL_MONTH
#define SQL_C_INTERVAL_DAY			SQL_INTERVAL_DAY