Supported Data Types
The following table shows information about the relational data types supported by PSQL. The SRDE converts the relational data types to ODBC default types unless another data type conversion is specified when
SQLGetData
or
SQLBindCol
is called. (For a discussion of data type conversions, refer to data types in the Microsoft ODBC documentation.)
See
PSQL Transactional and Relational Data Types
in
SQL Engine Reference
for the following information about the data types:
•
PSQL metadata type code
•
Size
•
Create and Add parameters
•
Notes specific to each data type
Table 8
PSQL Supported ODBC Data Types
Relational Type
ODBC Type (code)
1
BFLOAT4
SQL_REAL(7)
BFLOAT8
SQL_DOUBLE(8)
BIGINT
SQL_DECIMAL(3)
BINARY
SQL_BINARY(-2)
BIT
SQL_BIT(-7)
CHAR
SQL_CHAR(1)
CURRENCY
SQL_DECIMAL(3)
DATE
SQL_DATE(9)
DATETIME
SQL_TIMESTAMP(11)
DECIMAL
SQL_DECIMAL(3)
DOUBLE
SQL_DOUBLE(8)
IDENTITY
SQL_INTEGER(4)
INTEGER
SQL_INTEGER(4)
LONGVARBINARY
SQL_LONGVARBINARY(-4)
LONGVARCHAR
SQL_LONGVARCHAR(-1)
NCHAR
SQL_WCHAR(-8)
NLONGVARCHAR
SQL_WLONGVARCHAR(-10)
NUMERIC
SQL_NUMERIC(2)
NUMERICSA
SQL_NUMERIC(2)
NUMERICSLB
SQL_NUMERIC(2)
NUMERICSLS
SQL_NUMERIC(2)
NUMERICSTB
SQL_NUMERIC(2)
NUMERICSTS
SQL_NUMERIC(2)
NVARCHAR
SQL_WVARCHAR(-9)
REAL
SQL_REAL(7)
SMALLIDENTITY
SQL_SMALLINT(5)
SMALLINT
SQL_SMALLINT(5)
TIME
SQL_TIME(10)
TIMESTAMP
SQL_TIMESTAMP(11)
TINYINT
SQL_TINYINT(-6)
UBIGINT
SQL_DECIMAL(3)
UINTEGER
SQL_INTEGER(4)
UNIQUEIDENTIFIER
SQL_GUID(-11)
USMALLINT
SQL_SMALLINT(5)
UTINYINT
SQL_TINYINT(-6)
VARCHAR
SQL_VARCHAR(12)
1
SQL_FLOAT and SQL_VARBINARY are not supported by PSQL