Not
Bu sayfaya erişim yetkilendirme gerektiriyor. Oturum açmayı veya dizinleri değiştirmeyi deneyebilirsiniz.
Bu sayfaya erişim yetkilendirme gerektiriyor. Dizinleri değiştirmeyi deneyebilirsiniz.
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 |