diff options
| author | Hiroshi Inoue <inoue@tpf.co.jp> | 2002-05-22 05:51:03 +0000 |
|---|---|---|
| committer | Hiroshi Inoue <inoue@tpf.co.jp> | 2002-05-22 05:51:03 +0000 |
| commit | 79420840ee4f56b8399d3f526bb45ce788198e2e (patch) | |
| tree | 83027ac6beca92e86847cf9468d58e9385bcc6fc /src/interfaces/odbc/pgtypes.c | |
| parent | 6c6f395a8aca8a9525d62cbf46fbafd130bdb9e5 (diff) | |
| download | postgresql-79420840ee4f56b8399d3f526bb45ce788198e2e.tar.gz postgresql-79420840ee4f56b8399d3f526bb45ce788198e2e.zip | |
1) Support Keyset Driven driver cursors.
2) Supprt ARD precision/scale and SQL_C_NUEMRIC.
3) Minimal implementation of SQLGetDiagField().
4) SQLRowCount() reports the result of SQLSetPos and SQLBulkOperation.
5) int8 -> SQL_NUMERIC for Microsoft Jet.
6) Support isolation level change.
7) ODBC3.0 SQLSTATE code.
8) Append mode log files.
Diffstat (limited to 'src/interfaces/odbc/pgtypes.c')
| -rw-r--r-- | src/interfaces/odbc/pgtypes.c | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/src/interfaces/odbc/pgtypes.c b/src/interfaces/odbc/pgtypes.c index 74df2a79e93..fe0d5b86dea 100644 --- a/src/interfaces/odbc/pgtypes.c +++ b/src/interfaces/odbc/pgtypes.c @@ -101,7 +101,8 @@ Int2 sqlTypes[] = { }; #if (ODBCVER >= 0x0300) && defined(OBDCINT64) -#define ALLOWED_C_BIGINT SQL_C_SBIGINT +/* #define ALLOWED_C_BIGINT SQL_C_SBIGINT */ +#define ALLOWED_C_BIGINT SQL_C_CHAR /* Delphi should be either ? */ #else #define ALLOWED_C_BIGINT SQL_C_CHAR #endif @@ -286,11 +287,13 @@ pgtype_to_concise_type(StatementClass *stmt, Int4 type) /* Change this to SQL_BIGINT for ODBC v3 bjm 2001-01-23 */ case PG_TYPE_INT8: + if (conn->ms_jet) + return SQL_NUMERIC; /* maybe a little better than SQL_VARCHAR */ #if (ODBCVER >= 0x0300) - if (!conn->ms_jet) - return SQL_BIGINT; -#endif /* ODBCVER */ + return SQL_BIGINT; +#else return SQL_VARCHAR; +#endif /* ODBCVER */ case PG_TYPE_NUMERIC: return SQL_NUMERIC; |