sqlgettypeinfo.c

来自「这个是内存数据库的客户端」· C语言 代码 · 共 1,091 行 · 第 1/3 页

		NULL,		       /* literal_prefix */
		NULL,		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		SQL_FALSE,	       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		SQL_FALSE,	       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_SMALLINT,	       /* sql_data_type */
		-1,		       /* sql_datetime_sub */
		10,		       /* num_prec_radix */
		-1,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"float",	       /* type_name */
		SQL_FLOAT,	       /* data_type */
		DBL_MANT_DIG,	       /* column_size */
		NULL,		       /* literal_prefix */
		NULL,		       /* literal_suffix */
		NULL,		       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		SQL_FALSE,	       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		SQL_FALSE,	       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_FLOAT,	       /* sql_data_type */
		-1,		       /* sql_datetime_sub */
		2,		       /* num_prec_radix */
		-1,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"real",		       /* type_name */
		SQL_REAL,	       /* data_type */
		FLT_MANT_DIG,	       /* column_size */
		NULL,		       /* literal_prefix */
		NULL,		       /* literal_suffix */
		NULL,		       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		SQL_FALSE,	       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		SQL_FALSE,	       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_REAL,	       /* sql_data_type */
		-1,		       /* sql_datetime_sub */
		2,		       /* num_prec_radix */
		-1,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"double",	       /* type_name */
		SQL_DOUBLE,	       /* data_type */
		DBL_MANT_DIG,	       /* column_size */
		NULL,		       /* literal_prefix */
		NULL,		       /* literal_suffix */
		NULL,		       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		SQL_FALSE,	       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		SQL_FALSE,	       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_DOUBLE,	       /* sql_data_type */
		-1,		       /* sql_datetime_sub */
		2,		       /* num_prec_radix */
		-1,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"varchar",	       /* type_name */
		SQL_VARCHAR,	       /* data_type */
		1000000,	       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"length",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_TRUE,	       /* case_sensitive */
		SQL_SEARCHABLE,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		-1,		       /* minimum_scale */
		-1,		       /* maximum_scale */
		SQL_VARCHAR,	       /* sql_data_type */
		-1,		       /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		-1,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"date",		       /* type_name */
		SQL_TYPE_DATE,	       /* data_type */
		10,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		NULL,		       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		-1,		       /* minimum_scale */
		-1,		       /* maximum_scale */
		SQL_DATETIME,	       /* sql_data_type */
		SQL_CODE_DATE,	       /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		-1,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"time",		       /* type_name */
		SQL_TYPE_TIME,	       /* data_type */
		12,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		NULL,		       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		-1,		       /* minimum_scale */
		-1,		       /* maximum_scale */
		SQL_DATETIME,	       /* sql_data_type */
		SQL_CODE_TIME,	       /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		-1,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"timestamp",	       /* type_name */
		SQL_TYPE_TIMESTAMP,    /* data_type */
		23,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		-1,		       /* minimum_scale */
		-1,		       /* maximum_scale */
		SQL_DATETIME,	       /* sql_data_type */
		SQL_CODE_TIMESTAMP,    /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		-1,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"interval year",       /* type_name */
		SQL_INTERVAL_YEAR,     /* data_type */
		9,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_INTERVAL,	       /* sql_data_type */
		SQL_CODE_YEAR,	       /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		9,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"interval month",      /* type_name */
		SQL_INTERVAL_MONTH,    /* data_type */
		10,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		"month_interval",      /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_INTERVAL,	       /* sql_data_type */
		SQL_CODE_MONTH,	       /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		10,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"interval day",	       /* type_name */
		SQL_INTERVAL_DAY,      /* data_type */
		5,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_INTERVAL,	       /* sql_data_type */
		SQL_CODE_DAY,	       /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		5,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"interval hour",       /* type_name */
		SQL_INTERVAL_HOUR,     /* data_type */
		6,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_INTERVAL,	       /* sql_data_type */
		SQL_CODE_HOUR,	       /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		6,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"interval minute",     /* type_name */
		SQL_INTERVAL_MINUTE,   /* data_type */
		8,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_INTERVAL,	       /* sql_data_type */
		SQL_CODE_MINUTE,       /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		8,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"interval second",     /* type_name */
		SQL_INTERVAL_SECOND,   /* data_type */
		10,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		"sec_interval",	       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_INTERVAL,	       /* sql_data_type */
		SQL_CODE_SECOND,       /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		10,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"interval year to month",/* type_name */
		SQL_INTERVAL_YEAR_TO_MONTH,/* data_type */
		12,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_INTERVAL,	       /* sql_data_type */
		SQL_CODE_YEAR_TO_MONTH,/* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		9,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"interval day to hour",/* type_name */
		SQL_INTERVAL_DAY_TO_HOUR,/* data_type */
		8,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */
		SQL_INTERVAL,	       /* sql_data_type */
		SQL_CODE_DAY_TO_HOUR,  /* sql_datetime_sub */
		-1,		       /* num_prec_radix */
		5,		       /* interval_precision */
		NULL		       /* tuple */
	},
	{
		"interval day to minute",/* type_name */
		SQL_INTERVAL_DAY_TO_MINUTE,/* data_type */
		11,		       /* column_size */
		"'",		       /* literal_prefix */
		"'",		       /* literal_suffix */
		"precision",	       /* create_params */
		SQL_NULLABLE,	       /* nullable */
		SQL_FALSE,	       /* case_sensitive */
		SQL_PRED_BASIC,	       /* searchable */
		-1,		       /* unsigned_attribute */
		SQL_FALSE,	       /* fixed_prec_scale */
		-1,		       /* auto_unique_value */
		NULL,		       /* local_type_name */
		0,		       /* minimum_scale */
		0,		       /* maximum_scale */