1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
/// Used in `SQLColAttributeW`.
#[repr(u16)]
#[derive(Debug, PartialEq, Eq, Clone, Copy)]
pub enum Desc {
/// `SQL_DESC_COUNT`. Returned in `NumericAttributePtr`. The number of columns available in the
/// result set. This returns 0 if there are no columns in the result set. The value in the
/// `column_number` argument is ignored.
Count = 1001,
/// `SQL_DESC_TYPE`. Retruned in `NumericAttributePtr`. A numeric value that specifies the SQL
/// data type. When ColumnNumber is equal to 0, SQL_BINARY is returned for variable-length
/// bookmarks and SQL_INTEGER is returned for fixed-length bookmarks. For the datetime and
/// interval data types, this field returns the verbose data type: SQL_DATETIME or SQL_INTERVAL.
/// Note: To work against ODBC 2.x drivers, use `SQL_DESC_CONCISE_TYPE` instead.
Type = 1002,
/// `SQL_DESC_LENGTH`. Returned in `NumericAttributePtr`. A numeric value that is either the
/// maximum or actual character length of a character string or binary data type. It is the
/// maximum character length for a fixed-length data type, or the actual character length for a
/// variable-length data type. Its value always excludes the null-termination byte that ends the
/// character string.
Length = 1003,
/// `SQL_DESC_OCTET_LENGTH_PTR`.
OctetLengthPtr = 1004,
/// `SQL_DESC_PRECISION`. Returned in `NumericAttributePtr`. A numeric value that for a numeric
/// data type denotes the applicable precision. For data types SQL_TYPE_TIME,
/// SQL_TYPE_TIMESTAMP, and all the interval data types that represent a time interval, its
/// value is the applicable precision of the fractional seconds component.
Precision = 1005,
/// `SQL_DESC_SCALE`. Returned in `NumericAttributePtr`. A numeric value that is the applicable
/// scale for a numeric data type. For DECIMAL and NUMERIC data types, this is the defined
/// scale. It is undefined for all other data types.
Scale = 1006,
/// `SQL_DESC_DATETIME_INTERVAL_CODE`.
DatetimeIntervalCode = 1007,
/// `SQL_DESC_NULLABLE`. Returned in `NumericAttributePtr`. `SQL_ NULLABLE` if the column can
/// have NULL values; SQL_NO_NULLS if the column does not have NULL values; or
/// SQL_NULLABLE_UNKNOWN if it is not known whether the column accepts NULL values.
Nullable = 1008,
/// `SQL_DESC_INDICATOR_PTR`
IndicatorPtr = 1009,
/// `SQL_DESC_DATA_PTR`.
DataPtr = 1010,
/// `SQL_DESC_NAME`. Returned in `CharacterAttributePtr`. The column alias, if it applies. If
/// the column alias does not apply, the column name is returned. In either case,
/// SQL_DESC_UNNAMED is set to SQL_NAMED. If there is no column name or a column alias, an empty
/// string is returned and SQL_DESC_UNNAMED is set to SQL_UNNAMED.
Name = 1011,
/// `SQL_DESC_UNNAMED`. Returned in `NumericAttributePtr`. SQL_NAMED or SQL_UNNAMED. If the
/// SQL_DESC_NAME field of the IRD contains a column alias or a column name, SQL_NAMED is
/// returned. If there is no column name or column alias, SQL_UNNAMED is returned.
Unnamed = 1012,
/// `SQL_DESC_OCTET_LENGTH`. Returned in `NumericAttributePtr`. The length, in bytes, of a
/// character string or binary data type. For fixed-length character or binary types, this is
/// the actual length in bytes. For variable-length character or binary types, this is the
/// maximum length in bytes. This value does not include the null terminator.
OctetLength = 1013,
/// `SQL_DESC_ALLOC_TYPE`.
AllocType = 1099,
#[cfg(feature = "odbc_version_4")]
/// `SQL_DESC_CHARACTER_SET_CATALOG`.
CharacterSetCatalog = 1018,
#[cfg(feature = "odbc_version_4")]
/// `SQL_DESC_CHARACTER_SET_SCHEMA`
CharacterSetSchema = 1019,
#[cfg(feature = "odbc_version_4")]
// `SQL_DESC_CHARACTER_SET_NAME`.
#[cfg(feature = "odbc_version_4")]
CharacterSetName = 1020,
#[cfg(feature = "odbc_version_4")]
/// `SQL_DESC_COLLATION_CATALOG`
CollationCatalog = 1015,
#[cfg(feature = "odbc_version_4")]
/// `SQL_DESC_COLLATION_SCHEMA`
CollationSchema = 1016,
#[cfg(feature = "odbc_version_4")]
/// `SQL_DESC_COLLATION_NAME`
CollationName = 1017,
#[cfg(feature = "odbc_version_4")]
/// `SQL_DESC_USER_DEFINED_TYPE_CATALOG`
UserDefinedTypeCatalog = 1026,
#[cfg(feature = "odbc_version_4")]
/// `SQL_DESC_USER_DEFINED_TYPE_SCHEMA`.
UserDefinedTypeSchema = 1027,
#[cfg(feature = "odbc_version_4")]
/// `SQL_DESC_USER_DEFINED_TYPE_NAME`.
UserDefinedTypeName = 1028,
// Extended Descriptors
/// `SQL_DESC_ARRAY_SIZE`
ArraySize = 20,
/// `SQL_DESC_ARRAY_STATUS_PTR`
ArrayStatusPtr = 21,
/// `SQL_DESC_AUTO_UNIQUE_VALUE`. Returned in `NumericAttributePtr`. `true` if the column is an
/// autoincrementing column. `false` if the column is not an autoincrementing column or is not
/// numeric. This field is valid for numeric data type columns only. An application can insert
/// values into a row containing an autoincrement column, but typically cannot update values in
/// the column. When an insert is made into an autoincrement column, a unique value is inserted
/// into the column at insert time. The increment is not defined, but is data source-specific.
/// An application should not assume that an autoincrement column starts at any particular point
/// or increments by any particular value.
AutoUniqueValue = 11,
/// `SQL_DESC_BASE_COLUMN_NAME`. Returned in `CharacterAttributePtr`. The base column name for
/// the result set column. If a base column name does not exist (as in the case of columns that
/// are expressions), then this variable contains an empty string.
BaseColumnName = 22,
/// `SQL_DESC_BASE_TABLE_NAME`. Returned in `CharacterAttributePtr`. The name of the base table
/// that contains the column. If the base table name cannot be defined or is not applicable,
/// then this variable contains an empty string.
BaseTableName = 23,
/// `SQL_DESC_BIND_OFFSET_PTR`.
BindOffsetPtr = 24,
/// `SQL_DESC_BIND_TYPE`.
BindType = 25,
/// `SQL_DESC_CASE_SENSITIVE`. Returned in `NumericAttributePtr`. `true` if the column is
/// treated as case-sensitive for collations and comparisons. `false` if the column is not
/// treated as case-sensitive for collations and comparisons or is noncharacter.
CaseSensitive = 12,
/// `SQL_DESC_CATALOG_NAME`. Returned in `CharacterAttributePtr`. The catalog of the table that
/// contains the column. The returned value is implementation-defined if the column is an
/// expression or if the column is part of a view. If the data source does not support catalogs
/// or the catalog name cannot be determined, an empty string is returned. This VARCHAR record
/// field is not limited to 128 characters.
CatalogName = 17,
/// `SQL_DESC_CONCISE_TYPE`. Returned in `NumericAttributePtr`. The concise data type. For the
/// datetime and interval data types, this field returns the concise data type; for example,
/// SQL_TYPE_TIME or SQL_INTERVAL_YEAR.
ConciseType = 2,
/// `SQL_DESC_DATETIME_INTERVAL_PRECISION`
DatetimeIntervalPrecision = 26,
/// `SQL_DESC_DISPLAY_SIZE`. Returned in `NumericAttributePtr`. Maximum number of characters
/// required to display data from the column.
DisplaySize = 6,
/// `SQL_DESC_FIXED_PREC_SCALE`. Returned in `NumericAttributePtr`. `true` if the column has a
/// fixed precision and nonzero scale that are data source-specific. `false` if the column does
/// not have a fixed precision and nonzero scale that are data source-specific.
FixedPrecScale = 9,
/// `SQL_DESC_LABEL`. Returned in `CharacterAttributePtr`. The column label or title. For
/// example, a column named EmpName might be labeled Employee Name or might be labeled with an
/// alias. If a column does not have a label, the column name is returned. If the column is
/// unlabeled and unnamed, an empty string is returned.
Label = 18,
/// `SQL_DESC_LITERAL_PREFIX`. Returned in `CharacterAttributePtr`. This VARCHAR(128) record
/// field contains the character or characters that the driver recognizes as a prefix for a
/// literal of this data type. This field contains an empty string for a data type for which a
/// literal prefix is not applicable.
LiteralPrefix = 27,
/// `SQL_DESC_LITERAL_SUFFIX`. Returned in `CharacterAttributePtr`. This VARCHAR(128) record
/// field contains the character or characters that the driver recognizes as a suffix for a
/// literal of this data type. This field contains an empty string for a data type for which a
/// literal suffix is not applicable.
LiteralSuffix = 28,
/// `SQL_DESC_LOCAL_TYPE_NAME`. Returned in `CharacterAttributePtr`. This VARCHAR(128) record
/// field contains any localized (native language) name for the data type that may be different
/// from the regular name of the data type. If there is no localized name, then an empty string
/// is returned. This field is for display purposes only. The character set of the string is
/// locale-dependent and is typically the default character set of the server.
LocalTypeName = 29,
/// `SQL_DESC_MAXIMUM_SCALE`.
MaximumScale = 30,
/// `SQL_DESC_MINIMUM_SCALE`.
MinimumScale = 31,
/// `SQL_DESC_NUM_PREC_RADIX`. Returned in `NumericAttributePtr`. If the data type in the
/// SQL_DESC_TYPE field is an approximate numeric data type, this SQLINTEGER field contains a
/// value of 2 because the SQL_DESC_PRECISION field contains the number of bits. If the data
/// type in the SQL_DESC_TYPE field is an exact numeric data type, this field contains a value
/// of 10 because the SQL_DESC_PRECISION field contains the number of decimal digits. This field
/// is set to 0 for all non-numeric data types.
NumPrecRadix = 32,
/// `SQL_DESC_PARAMETER_TYPE`.
ParameterType = 33,
/// `SQL_DESC_ROWS_PROCESSED_PTR`.
RowsProcessedPtr = 34,
#[cfg(feature = "odbc_version_3_50")]
/// `SQL_DESC_ROWVER`.
RowVer = 35,
/// `SQL_DESC_SCHEMA_NAME`. Returned in `CharacterAttributePtr`. The schema of the table that
/// contains the column. The returned value is implementation-defined if the column is an
/// expression or if the column is part of a view. If the data source does not support schemas
/// or the schema name cannot be determined, an empty string is returned. This VARCHAR record
/// field is not limited to 128 characters.
SchemaName = 16,
/// `SQL_DESC_SEARCHABLE`. Returned in `NumericAttributePtr`. `SQL_PRED_NONE` if the column
/// cannot be used in a WHERE clause. `SQL_PRED_CHAR` if the column can be used in a WHERE
/// clause but only with the LIKE predicate. `SQL_PRED_BASIC` if the column can be used in a
/// WHERE clause with all the comparison operators except LIKE. `SQL_PRED_SEARCHABLE` if the
/// column can be used in a WHERE clause with any comparison operator. Columns of type
/// `SQL_LONGVARCHAR` and `SQL_LONGVARBINARY` usually return `SQL_PRED_CHAR`.
Searchable = 13,
/// `SQL_DESC_TYPE_NAME`. Returned in `CharacterAttributePtr`. Data source-dependent data type
/// name; for example, "CHAR", "VARCHAR", "MONEY", "LONG VARBINARY", or "CHAR ( ) FOR BIT DATA".
/// If the type is unknown, an empty string is returned.
TypeName = 14,
/// `SQL_DESC_TABLE_NAME`. Returned in `CharacterAttributePtr`. The name of the table that
/// contains the column. The returned value is implementation-defined if the column is an
/// expression or if the column is part of a view. If the table name can not be determined an
/// empty string is returned.
TableName = 15,
/// `SQL_DESC_UNSIGNED`. Returned in `NumericAttributePtr`. `true` if the column is unsigned (or
/// not numeric). `false` if the column is signed.
Unsigned = 8,
/// `SQL_DESC_UPDATABLE`. Returned in `NumericAttributePtr`. Column is described by the values
/// for the defined constants: `SQL_ATTR_READONLY`, `SQL_ATTR_WRITE`,
/// `SQL_ATTR_READWRITE_UNKNOWN`.
/// `Updatable` Describes the updatability of the column in the result set, not the column in
/// the base table. The updatability of the base column on which the result set column is based
/// may be different from the value in this field. Whether a column is updatable can be based on
/// the data type, user privileges, and the definition of the result set itself. If it is
/// unclear whether a column is updatable, `SQL_ATTR_READWRITE_UNKNOWN` should be returned.
Updatable = 10,
#[cfg(feature = "odbc_version_4")]
/// `SQL_DESC_MIME_TYPE`.
MimeType = 36,
}