Supported Data Types
DataExchange Data Types
Supported data types are covered in the following topics:
•
Data Types
•
Notes on Data Types
Data Types
The following table lists the PSQL data types supported by DataExchange.
PSQL Data Type
DataExchange Implementation
Can be Used as Primary Key for Replication
Bit
bool
no
Tinyint
byte
yes
Utinyint
byte
yes
Decimal
numeric
yes
Numeric1
numeric
no
Bigint1
numeric
no
Ubigint1
numeric
no
Currency1
numeric
no
Longvarbinary
blob
no
Binary
blob
no
Longvarchar
blob
no
Char2
string
yes
Varchar3
string
yes
Integer
long
yes
Uinteger
long
yes
Identity4
long
yes
Smallint
short
yes
Usmallint
short
yes
Smallidentity
short
yes
Float
double
yes
Real
double
yes
Double
double
yes
Date
timestamp
yes
Time
timestamp
yes
Timestamp
timestamp
yes
1Partially supported data type in PSQL. See the appendix on PSQL supported data types in PSQL SQL Engine Reference.
2Limited to 255 characters.
3Limited to 254 characters.
4Although Identity is supported in DataExchange for replication primary keys, using it for any part of a unique index is strongly discouraged.
Notes on Data Types
This topic lists special information regarding the use of data types in DataExchange.
DECIMAL
DECIMAL is implemented in DataExchange as a NUMERIC and can be use as a primary key for replication.
NUMERIC, BIGINT, UBIGINT and CURRENCY
The other data types that are implemented as NUMERICS cannot be used as primary keys for replication. These include NUMERIC, BIGINT, UBIGINT, and CURRENCY.
CHAR
The CHAR data type is limited to 255 characters.
VARCHAR
The VARCHAR data type is limited to 254 characters.
IDENTITY
Although you may use IDENTITY data types for primary keys in DataExchange, we strongly recommend that you not use this data type as part of a unique index.