إشعار
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تسجيل الدخول أو تغيير الدلائل.
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تغيير الدلائل.
An application calls SQLGetTypeInfo to determine which data types are supported by a data source and the characteristics of those data types. The following tables show a sample result set returned by SQLGetTypeInfo for a data source that supports SQL_CHAR, SQL_LONGVARCHAR, SQL_DECIMAL, SQL_REAL, SQL_DATETIME, SQL_INTERVAL_YEAR, and SQL_INTERVAL_DAY_TO_SECOND.
| TYPE_NAME | DATA_TYPE | COLUMN_SIZE | LITERAL_PREFIX | LITERAL_SUFFIX | CREATE_PARAMS | NULLABLE |
|---|---|---|---|---|---|---|
| "char" | SQL_CHAR | 255 | "'" | "'" | "length" | SQL_TRUE |
| "text" | SQL_LONGVARCHAR | 2147483647 | "'" | "'" | <Null> | SQL_TRUE |
| "decimal" | SQL_DECIMAL | 28 | <Null> | <Null> | "precision, scale" |
SQL_TRUE |
| "real" | SQL_REAL | 7 | <Null> | <Null> | <Null> | SQL_TRUE |
| "datetime" | SQL_TYPE_TIMESTAMP | 23 | "'" | "'" | <Null> | SQL_TRUE |
| "INTERVAL YEAR() TO YEAR" | SQL_INTERVAL_YEAR | 9 | "'" | "'" | "precision" | SQL_TRUE |
| "INTERVAL DAY() TO FRACTION(5)" | SQL_INTERVAL_DAY_TO_SECOND | 24 | "'" | "'" | "precision" | SQL_TRUE |
| DATA_TYPE | CASE_SENSITIVE | SEARCHABLE | UNSIGNED_ATTRIBUTE | FIXED_PREC_SCALE | AUTO_UNIQUE_VALUE | LOCAL_TYPE_NAME |
|---|---|---|---|---|---|---|
| SQL_CHAR | SQL_FALSE | SQL_SEARCHABLE | <Null> | SQL_FALSE | <Null> | "char" |
| SQL_LONGVARCHAR | SQL_FALSE | SQL_PRED_CHAR | <Null> | SQL_FALSE | <Null> | "text" |
| SQL_DECIMAL | SQL_FALSE | SQL_PRED_BASIC | SQL_FALSE | SQL_FALSE | SQL_FALSE | "decimal" |
| SQL_REAL | SQL_FALSE | SQL_PRED_BASIC | SQL_FALSE | SQL_FALSE | SQL_FALSE | "real" |
| SQL_TYPE_TIMESTAMP | SQL_FALSE | SQL_SEARCHABLE | <Null> | SQL_FALSE | <Null> | "datetime" |
| SQL_INTERVAL_YEAR | SQL_FALSE | SQL_SEARCHABLE | <Null> | SQL_FALSE | <Null> | "INTERVAL YEAR() TO YEAR" |
| SQL_INTERVAL_DAY_TO_SECOND | SQL_FALSE | SQL_PRED_BASIC | <Null> | SQL_FALSE | <Null> | "INTERVAL DAY() TO FRACTION(5)" |
| DATA_TYPE | MINIMUM_SCALE | MAXIMUM_SCALE | SQL_DATA_TYPE | SQL_DATETIME_SUB | NUM_PREC_RADIX | INTERVAL_PRECISION |
|---|---|---|---|---|---|---|
| SQL_CHAR | <Null> | <Null> | SQL_CHAR | <Null> | <Null> | <Null> |
| SQL_LONGVARCHAR | <Null> | <Null> | SQL_LONGVARCHAR | <Null> | <Null> | <Null> |
| SQL_DECIMAL | 0 | 28 | SQL_DECIMAL | <Null> | 10 | <Null> |
| SQL_REAL | <Null> | <Null> | SQL_REAL | <Null> | 10 | <Null> |
| SQL_TYPE_TIMESTAMP | 3 | 3 | SQL_DATETIME | SQL_CODE_TIMESTAMP | <Null> | 12 |
| SQL_INTERVAL_YEAR | 0 | 0 | SQL_INTERVAL | SQL_CODE_INTERVALYEAR | <Null> | 9 |
| SQL_INTERVAL_DAY_TO_SECOND | 5 | 5 | SQL_INTERVAL | SQL_CODE_INTERVALDAY_TO_SECOND | <Null> | 9 |